T-SQL Data Manipulation

INSERT Records into an IDENTITY field

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This segment shows how to create a table with an identity column that automically numbers new rows to provide unique values for a primary key field. It also shows the needed syntax to override that autonumbering when you need to force specific key values to be assigned.

Keywords

  • SQL Server
  • T-SQL
  • database
  • statements Identity Column
  • Identity Field
  • Autonumbering
  • Primary Key

About this video

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