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, 1460🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...