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