The Basics of Inserting Data into a SQL Server Table


 

Entry in Greg Larsen series on Learning T-SQL. The series so far:

The basic T-SQL Select Statement Ordering a result set in SQL Server The ins and outs of joining tables in SQL Server Summarizing data using GROUP BY and HAVING The Basics of Inserting Data into a SQL Server Table

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with