In Transact-SQL (T-SQL) INSERT allows us to add one or more rows into a table. In this lab we’ll learn different ways to insert data into a SQL Server table. In first exercise we will learn to insert a single new row into a table. In second exercise we will learn to insert multiple rows into a table. In third exercise we will learn to insert data from a SELECT query. In fourth exercise we will learn to insert data using EXEC. In fifth exercise we will learn to insert the values using SELECT INTO. In sixth exercise we will learn to import data using BULK INSERT. In seventh exercise we will learn to insert records into IDENTITY column. In eighth exercise we will learn to insert values using SEQUENCE object. Ninth exercise is a Self-Assessment, where a problem is given and you need to solve on your own. Tenth exercise presents the TSQL challenge that needs to be solved (slightly tougher than Self-Assessment).

Subscribe to Download


Version1.0
Download5
File Size921.74 KB
Create DateSeptember 12, 2016
Last UpdatedSeptember 12, 2016
Error Handling in SQL Server
LAG and LEAD Functions in SQL Server