Assigning Values with the Select Statement : Select Variables « Transact SQL « SQL Server / T-SQL






Assigning Values with the Select Statement

 


3>
4> Declare     @LastName varchar(50),
5>             @FirstName varchar(11),
6>             @BirthDate smalldatetime
7>
8>
9>
10> Select @LastName = 'Smith'
11> GO
1>

 








Related examples in the same category

1.SELECT is usually used to assign variable values