Declare a table type variable and query it : Declare « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Declare

7> CREATE TABLE Orders (
8>      OrderID int NOT NULL ,
9>      CustomerID nchar (5) NULL ,
10>     EmployeeID int NULL ,
11>     OrderDate datetime NULL ,
12>     RequiredDate datetime NULL ,
13>     ShippedDate datetime NULL ,
14>     ShipVia int NULL ,
15>     Freight money NULL DEFAULT (0),
16>     ShipName nvarchar (40) NULL ,
17>     ShipAddress nvarchar (60) NULL ,
18>     ShipCity nvarchar (15) NULL ,
19>     ShipRegion nvarchar (15) NULL ,
20>     ShipPostalCode nvarchar (10) NULL ,
21>     ShipCountry nvarchar (15) NULL
22> )
23> GO
1>
2>    DECLARE @MyTable Table
3>    (
4>       OrderID      int,
5>       CustomerID   char(5)
6>    )
7>
8>    INSERT INTO @MyTable
9>       SELECT OrderID, CustomerID
10>       FROM Orders
11>       WHERE OrderID BETWEEN 10240 AND 10250
12>
13>    SELECT *
14>    FROM @MyTable
15> GO

(0 rows affected)
OrderID     CustomerID
----------- ----------

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