Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
Set « Transact SQL « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Transact SQL
Set
20.4.Set
20.4.1.
Syntax for Variable Assignment with the SET Statement
20.4.2.
Using SET to Assign Variables
20.4.3.
Assign the function result to the variable
20.4.4.
Return the variable value
20.4.5.
Use set command to update a variable
20.4.6.
Concatenating Variables
20.4.7.
SET variable and column in one command