Hi,

The data types used in the tables is varchar. So I understand that its not unicode supported. So I was thinking that I should be using -n option. Do you...

Hi Kenneth,

I tried that & its found working.

Because of this problem I got to learn about SET IDENTITY_INSERT off &

DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value) properties

Hi,

Thanks for your kind help. I was trying to find out the reason for the wrong result my program was fetching & somebody told me that this could be the...

Hi,

Thanks everyone for your kind suggestions.

Franks dynamic SQL is doing the trick. But since it is advicible not to use dynamic SQL, I changed my logic to acheive the results.

what Frank said...