T-SQL Basics: Variables
T-SQL variables allows you to store and assign values in your T-SQL code. Variables is a storage unit in programming which allows you to refer back to it at a later time.
T-SQL variables have the following characteristics:
- Local variables must be prefixed @
- Global variables must be prefixed with @@
- Must be declared with the DECLARE statement
- Must specify the data type when declared
DECLARE @employeeID INT;
DECLARE @firstName CHAR(10), @lastName CHAR(20);
As you can see from the above example you can declare a single variable or declare multiple variables with a comma separated list.
Setting variables
SET @employeeID = 1;
SET @firstName='Davolio';
SET @lastName='Nancy';
The above example uses the SET statement assign values to the variables one at a time.
To assign values to multiple variables with one statement you can use the SELECT statement.
SELECT @employeeID=1,@firstName='Dovolio',@lastName='Nancy';
Convert INT Variable To String
Convert(CHAR,@employeeID);
Comments
Post a Comment