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, 1954🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...