Mega Code Archive
Declare a table type variable and query it
<![CDATA[
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>
]]>