SQL Server - DECLARE Statements in SQL Server Transact-SQL

Home > SQL Server

DECLARE Statements in SQL Server Transact-SQL

Q

How to declare a variable in SQL Server Transact-SQL? How to use the DECLARE statements?

✍: FYIcenter.com

A

In Transact-SQL, you must use DECLARE statements to declare variables.

Declaring a variable is to define the variable name and the variable data type.

In Transact-SQL, you can:

Declare a single variable in a single DECLARE statement.
Declare multiple variables in a single DECLARE statement using comma (,) as the delimiter.
Declare variables with initial values using the assignment operator =.

Here are some example on how to declare variables in Transact-SQL:

DECLARE @country CHAR(3);
DECLARE @name NVARCHAR(80), @city NVARCHAR(80);
DECLARE @price MONEY = 9.99;
DECLARE @now DATETIME = GETDATE();

⇒Variables and Data Types in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-04-04, 855👍, 0💬

PRINT Statements in SQL Server Transact-SQL
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transact-SQL, you can use PRINT statements to print values on the console of the client tool, in the syntax of: PRINT <value> When a PRINT statement is executed, the system will: Print the val... 2017-04-01, 878👍, 0💬

DECLARE Statements in SQL Server Transact-SQL
How to declare a variable in SQL Server Transact-SQL? How to use the DECLARE statements? In Transact-SQL, you must use DECLARE statements to declare variables. Declaring a variable is to define the variable name and the variable data type. In Transact-SQL, you can: Declare a single variable in a sin... 2017-04-04, 856👍, 0💬

Differences of CHAR and VARCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and VARCHAR in SQL Server Transact-SQL? CHAR and VARCHAR are both used to store code page based 1-byte character strings in Transact-SQL. But they have the following main differences: CHAR(n) stores character strings with a fixed length, n bytes, storage format.... 2017-04-04, 836👍, 0💬

SET Statements in SQL Server Transact-SQL
How to assign value to a variable in SQL Server Transact-SQL? How to use the SET statements? In Transact-SQL, you can use SET statements to assign values to variables using the assignment operator =, in the syntax of: SET @variable = <value> When an SET statement is executed, the syste... 2017-04-04, 817👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.