Assign Value « Transact SQL « SQL Server / T-SQL






1.Using SELECT to Assign Variables
2.Assign value from select statement to a variable
3.Assign query result to a variable
4.Dynamically set the number of rows returned