we can use table variable in UDF's. But performance issues will raise.....:w00t:

if we use delete instead of truncate reseed will not work...... the answer should be 4,8........:-P

there is 5 answers are available....????????

really very tough one...

Easy one... make me think lot

nice to recall everything... easy one....:cool:

kk thanks for your reply.... but i try to ask how to drop that column.... i cannot drop that column.... nice article very useful to me.......:-)

Actually i am new for table design. i added one new column like [insred_name] in existing table with spelling mistake. then i changed that column name...

this should work!!!!!

Select * from #temp2

EXCEPT

Select * from #temp1