操作 SP 结果集

USE [CommonLotteryDB]
GO

/存储过程返回的结果集，用临时表来存储/

DECLARE @return_value INT

IF OBJECT_ID(N’tempdb..#temp’) IS NOT NULL
DROP TABLE #temp;

CREATE TABLE #temp
(
Random INT ,
PacketID BIGINT
)

INSERT INTO #temp
EXEC @return_value = [dbo].[Lottery] @EventID = 4,
@CombineCondition = 11, @LotteryCount = 10

SELECT ‘Return Value’ = @return_value

SELECT *
FROM #temp

GO