一个调用存储过程的例子 ,结果导入表变量

USE [Shop]
GO

DECLARE @return_value int

DECLARE @TBL_Result as table
(
[shohin_id] [char](4) NOT NULL,
[shohin_mei] [varchar](100) NOT NULL,
[shohin_bunrui] [varchar](32) NOT NULL,
[hanbai_tanka] [int] NULL,
[shiire_tanka] [int] NULL,
[torokubi] [datetime] NULL
)

EXEC [dbo].[PROC_Test] @PARAM1 = N'0001' into @TBL_Result

SELECT * FROM @TBL_Result

EXEC @return_value = [dbo].[PROC_Test]
@PARAM1 = N'0001'

SELECT 'Return Value' = @return_value