Collections:
What Is Variable in SQL Server Transact-SQL
What is a variable in SQL Server Transact-SQL?
✍: FYIcenter.com
A variable in Transact-SQL is a symbolic name representing
a memory storage that holds a piece of data.
A variable has the following the components:
1. Variable name - A symbolic name to represent the variable. Variable names in Transact-SQL must starts with the @ character. For example, @count and @price are variable names.
2. Variable data type - A predefined format on how the data is stored in the variable. For example, INTEGER and MONEY are variable types.
3. Variable value - The value represented by the data in variable storage. For example, 3 and 9.99 could be variable values stored in @count and @price variables.
4. Variable scope - The period of execution in which the variable is declared, assigned with a value and required to hold the value.
Here is an example using variables in Transact-SQL in a statement batch:
DECLARE @price MONEY; SET @price = 9.99; PRINT @price;
In the above example:
⇒ List of Data Types in SQL Server Transact-SQL
⇐ Variables and Data Types in SQL Server Transact-SQL
2017-04-22, 1535🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...