SQL Server Express 2008 R2 Tutorial 6 - Inserting Data in Tables Using the While Loop



This tutorial will start by declaring variables. Integer and varchar are shown. The @ is used to declare variables. For a list of supported variables see the MSDN variable page.

The while loop will be used to insert data into the table.

Cast, Set and Count commands are also used within this tutorial.

Code Downloads 
while loop.sql.zip
People_List.sql.zip
SampleDb.sql.zip