-- 1. Table type variables
1. Declare table-type variables
Declare @ TBL table (col1 int, col2 nvarchar (10) 2. declare a temporary table -- Create Table # T (col1 varchar (10), col2 varchar (10 )) -- insert # T exec tabletestsss -- select * from # t -- drop table # t -- 2. query Result set -- 1. stored Procedure: Create procedure tabletestsssasdeclare @ ordershippertab table (col1 varchar (80), col2 varchar (80) insert @ ordershippertab values ('11', '12 ') insert @ ordershippertab values ('21', '22') insert @ ordershippertab values ('31', '32') insert @ ordershippertab values ('42', '42 ') select * From @ ordershippertabgo -- declares a temporary table by calling the query analyzer # T inserts the query result set, reads it, and drops -- Create Table # T (col1 varchar (10 ), col2 varchar (10) -- insert # T exec tabletestsss -- select * from # t -- drop table # T2. create function gettable (@ age INT) returns @ result table (col1 int, col2 nvarchar (20) as begininsert into @ result select * From tbl3 where age >=@ agereturn -- no return value here end -- Verification
select * from getTable(1)