I have two databases on SQL Server 2000 named TLCTest and TLC.
I wish to copy the contents of a table named "Container" in TLCTest to a
table also named "Container" in TLC.
I think that the best way to do this is through an SQL INSERT statement.
However I can't seem to get the syntax correct.
I think this is kind of what I need but the exact syntax eludes me...:
INSERT Dbo.TLC.Container (ContainerNo,Type,Size)
VALUES (SELECT ContainerNo, Type, Size FROM dbo.TLCTest.Container)
Am I right in assuming that I can simply execute this in Query yser?