The DECLARE statement has a pretty simple syntax: : Declare « Transact SQL « SQL Server / T-SQL Tutorial






5> --DECLARE @<variable name> <variable type>[,
6> --        @<variable name> <variable type>[,
7> --        @<variable name> <variable type>]]
8> --
9> --Setting Variables Using SET
10>
11>
12> CREATE TABLE OrderDetails (
13>     OrderID int NOT NULL ,
14>     ProductID int NOT NULL ,
15>     UnitPrice money NOT NULL DEFAULT (0),
16>     Quantity smallint NOT NULL DEFAULT (1),
17>     Discount real NOT NULL DEFAULT (0)
18> )
19> GO
1> INSERT OrderDetails VALUES(10248,11,14,12,0)
2> INSERT OrderDetails VALUES(10248,42,9.8,10,0)
3> INSERT OrderDetails VALUES(10248,72,34.8,5,0)
4> INSERT OrderDetails VALUES(10249,14,18.6,9,0)
5> INSERT OrderDetails VALUES(10249,51,42.4,40,0)
6> INSERT OrderDetails VALUES(10250,41,7.7,10,0)
7> INSERT OrderDetails VALUES(10250,51,42.4,35,0.15)
8> INSERT OrderDetails VALUES(10250,65,16.8,15,0.15)
9> INSERT OrderDetails VALUES(10251,22,16.8,6,0.05)
10> INSERT OrderDetails VALUES(10251,57,15.6,15,0.05)
11> go

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>    DECLARE @TotalCost money
3>
4>    SET @TotalCost = 10
5>    SET @TotalCost = @TotalCost * 1.1
6>
7>
8>    DECLARE @Test money
9>
10>    select @Test = MAX(UnitPrice) FROM OrderDetails
11>    SELECT @Test
12> GO

---------------------
              42.4000

(1 rows affected)
1>
2> drop table OrderDetails;
3> GO








20.1.Declare
20.1.1.The DECLARE statement has a pretty simple syntax:
20.1.2.It is possible to define several variables in a single Declare statement.
20.1.3.The names of variables must begin with @
20.1.4.Simple SELECT query written using variables for field names.
20.1.5.Declare a table type variable and query it
20.1.6.DECLARE @Out Int (get value out of a procedure)
20.1.7.DECLARE @Out Int