T-SQL Data Manipulation

INSERT Records from Existing Tables

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This segment shows two supported mechanisms for copying rows from one table and inserting those rows into another table. Then expands upon the syntax to show how to derive new rows by selecting only specific columns from the source table.

Keywords

  • SQL Server
  • T-SQL
  • Insert Into
  • Select Into

About this video

Author(s)
John Deardurff
First online
10 May 2019
DOI
https://doi.org/10.1007/978-1-4842-4993-2_5
Online ISBN
978-1-4842-4993-2
Publisher
Apress
Copyright information
© John Deardurff 2019