sql server issue
-
I am a junior software engineer..am getting so much of doubts on sql server 2000.Tell you..please solve my issue to work with it better. Ok the matter is ,how can i insert a lot of strings in the same time to the same field ?. for example..I want to insert 'xp','vista','mac' and a hundreds of other names again. So how can i add those hundreds of strings with one querry. and it should go to one and same field help me please...
-
I am a junior software engineer..am getting so much of doubts on sql server 2000.Tell you..please solve my issue to work with it better. Ok the matter is ,how can i insert a lot of strings in the same time to the same field ?. for example..I want to insert 'xp','vista','mac' and a hundreds of other names again. So how can i add those hundreds of strings with one querry. and it should go to one and same field help me please...
Hi, I think you can use BULK INSERT for this... Here is a sample link , there are a lot of resources for this. Try simple online search for more details.. http://msdn2.microsoft.com/en-us/library/ms188365.aspx[^] http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ts_ba-bz_4fec.htm[^] Regards! Charith
jayasshc