Quick Reminder: How to Insert Rows Into One Table from Another Table

Just a quick reminder:

INSERT INTO dbo.TargetTable (
   FirstName,
   MiddleInitial,
   LastName,
   EmployeeID,
   DepartmentNumber
)
SELECT
   FirstName,
   MiddleInitial,
   LastName,
   EmployeeID,
   DepartmentNumber
FROM
   dbo.SourceTable


Comments

Popular posts from this blog

Using Reference Aliases

List of Visual Studio Keyboard Shortcuts