用户自定义函数
CREATE FUNCTION TableTest()
RETURNS @OrderShipperTab TABLE (col1 varchar(80),col2 varchar(80))
AS BEGIN
INSERT @OrderShipperTab values('11','12')
INSERT @OrderShipperTab values('21','22')
INSERT @OrderShipperTab values('31','32')
INSERT @OrderShipperTab values('42','42')
RETURN
END
查询分析器
declare @testTable table (col1 varchar(10),col2 varchar(10))
insert @testTable values('11','12')
insert @testTable values('21','22')
select * from @testTable
存储过程中
CREATE PROCEDURE tableTest
--参数
AS
declare @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 @OrderShipperTab
GO