Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Move table from 1 db to another?
Insert into database2.dbo.table2 select * from database1.dbo.table1 did you try adding explicit fields Insert into database2.dbo.table2 (field1, field2, ...) select (fieldxz,fieldpdq,myfield) from database1.dbo.table1 this is common for insert with imbedded select within one database and...- sloat
- Post #5
- Forum: Microsoft SQL Server: Programming
