-- DESTINATION TABLE SHOULD EXIST
USE MASTER
INSERT INTO testDatabase.[dbo].destTable
SELECT CategoryID,CategoryName FROM Northwind.[dbo].[Categories]
-- DESTINATION TABLE MAY NOT EXIST, WILL BE CREATED AT RUNTIME
USE MASTER
SELECT [EmployeeID],[LastName],[FirstName]
INTO testDatabase.[dbo].destTable
FROM Northwind.[dbo].[Employees]
0 comments:
Post a Comment