Use local variable in a select statement : Query Select « Query « SQL Server / T-SQL Tutorial

3> create table Billings (
4>     BankerID           INTEGER,
5>     BillingNumber      INTEGER,
6>     BillingDate        datetime,
7>     BillingTotal       INTEGER,
8>     TermsID            INTEGER,
9>     BillingDueDate     datetime ,
10>     PaymentTotal       INTEGER,
11>     CreditTotal        INTEGER
12>
13> );
14> GO
1>
2> INSERT INTO Billings VALUES (1, 1, '2005-01-22', 165, 1,'2005-04-22',123,321);
3> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (2, 2, '2001-02-21', 165, 1,'2002-02-22',123,321.);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (3, 3, '2003-05-02', 165, 1,'2005-04-12',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (4, 4, '1999-03-12', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (5, 5, '2000-04-23', 165, 1,'2005-04-17',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (6, 6, '2001-06-14', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (7, 7, '2002-07-15', 165, 1,'2005-04-19',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (8, 8, '2003-08-16', 165, 1,'2005-04-20',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (9, 9, '2004-09-17', 165, 1,'2005-04-21',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (0, 0, '2005-10-18', 165, 1,'2005-04-22',123,321);
2> GO

(1 rows affected)
1>
2> DECLARE @intvar int
3> SET @intvar = 1
4>
5> SELECT TermsID, BillingNumber 'Category name',
6>     @intvar 'Local variable'
7> FROM Billings
8> GO
TermsID     Category name Local variable
----------- ------------- --------------
          1             1              1
          1             2              1
          1             3              1
          1             4              1
          1             5              1
          1             6              1
          1             7              1
          1             8              1
          1             9              1
          1             0              1

(10 rows affected)
1>
2>
3> drop table Billings;
4> GO
1>
2>

1.1.Query Select
	1.1.1.	The basic syntax of the SELECT statement
	1.1.2.	The operators you can use in a search condition
	1.1.3.	Both uppercase and lowercase statements are acceptable, a query could be written as follows:
	1.1.4.	Operator Precedence
	1.1.5.	asterisk (*) specifies all columns of the named tables in the FROM clause
	1.1.6.	A SELECT statement that retrieves rows with non-zero values
	1.1.7.	A SELECT statement that retrieves two columns and a calculated value for a specific Billing
	1.1.8.	retrieve specific columns
	1.1.9.	A SELECT statement that retrieves three columns from each row, sorted in descending sequence by Billing total
	1.1.10.	A SELECT statement that returns an empty result set
	1.1.11.	SELECT 1.0 + 3.0 / 4.0 -- Returns 1.75
	1.1.12.	SELECT (1.0 + 3.0) / 4.0 -- Returns 1.00
	1.1.13.	The specification column_name [as] column_heading
	1.1.14.	Table alias
	1.1.15.	add a WHERE clause and group by
	1.1.16.	A SELECT statement that uses the CHAR function to format output
	1.1.17.	Use local variable in a select statement
	1.1.18.	Using SELECT to Create a Script