Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Import script

Author  Topic 

d3ng
Yak Posting Veteran

83 Posts

Posted - 2007-09-07 : 22:18:20
How I would like to ask regarding on how to import a data using SQL Scripts. I want to import the data of a specific table from a different database instead of using a import/export options.

for ex.
from database_a.dbo.items to database_b.dbo.items


Tatas move

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-07 : 22:53:22
Take look at 'insert into table1 ... select ... from table2 ...' in books online.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-08 : 02:04:36
Also, This forum is to post a workable script and to ask a question. you should post your question at proper forum

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -