SQL Server Performance Forum – Threads Archive

Data loading in SQL

hey ppl,
Dores anyone know how can we write a stored procedure in SQL SERVER 2000 for loading data from one database to other database on the same server.
Thanks,
Gaurang

Hi,
select into [database].[dbo].[table2].[colum(s)1] into [database].[dbo].[table1] from [database].[dbo].[table2] where somecondition …. Refer select into in BOL for more. and you could do this using BCP and DTS tooo. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

If the table already exists before that operation you can use the INSERT INTO … SELECT syntax described in BOL. —
Frank Kalis
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Books OnLine is your friend to refer the syntax and code example. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>