Data loading in SQL | SQL Server Performance Forums

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.
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
Heute schon gebloggt?
Books OnLine is your friend to refer the syntax and code example. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.