What would be the into statement when I am trying to do an insert into another database from SQL
basically want to do something like this but its not working quite right
insert into DatabaseName.TableName
Any help would be greatly appreciated...Thanksinsert server.db.dbo.table values(...)
server - linked server. See BOL fro details.|||You can use SELECT...INTO to create an identical table definition (different table name) with no data by having a FALSE condition in the WHERE clause.
To transfer data between the databases you can take help of DTS which is easy and manageble.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment