Basic syntax for SQL Server programming

--Simple assignment
DECLARE @a int
Set @a=5
Print @a

--Assigning values using the SELECT statement
declare @user1 nvarchar (50)
Select @user1 = ' Zhang San '
Print @user1
declare @user2 nvarchar (50)
Select @user2 = Name from St_user where id=1
Print @user2

-while Loop calculates 1 to 100 of the and
DECLARE @a int
DECLARE @sum int
Set @a=1
Set @sum =0
While @a<=100
Begin
Set @[email protected]
Set @a+=1
End
Print @sum

Basic syntax for SQL Server programming