puterkrazy
Programmer
I need to transfer data to another database, what are SQL commands to do this and what is the best way?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
INSERT server2.db1.dbo.t1 (col1, col2, col3)
SELECT col1, col2, col3
FROM t1
SELECT col1, col2, col3
INTO server2.db1.dbo.t1
FROM t1