SQL: Copy data from one to another table(Insert into....select into...)

-- 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]

Posted in: GENERAL SYNTAX_SQL,SQL