Please start any new threads on our new site at 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 

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

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

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


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

- Advertisement -