is it possible to use table variable as a

input parameter for another query

i am using SQL Server 2005 Developer Edition

Okey got it ,thanx for your explanation

actaully i have created table in design view

in that i have created two identity column

but fail to note that when i made Col1...

actually first identity column is regular id and second identity column is primary Key and will be use for reference

you mean table design is problem, i should keep only one...

thanx for article u have mention it gave a clear picture now

I have took abc nvarchar (4000) as it will store the summary and i have put the condition that...

thanx for the valuable suggestion,

but i have one question

should the sequence of which i give columns name matters

create index pindex on (id,Full_Name,quali)

and can i have a single index on Full_Name...

Hi, thanx for your suggestion

hi ,i am creating a database and want to copy around 10 million records

into table X which is having 10 fileds

if you calculate in term of bytes

int (4...