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.
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.itemsTatas 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. |
|
|
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 forumMadhivananFailing to plan is Planning to fail |
|
|
|
|
|