22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @ID INT,@Num INT=10
EXEC P1 @ID OUTPUT,@Num
SELECT @ID
CREATE TABLE Tab(ID INT IDENTITY,Num int)
GO
CREATE PROCEDURE P1(@ID INT=NULL OUTPUT,@Num int)
AS
INSERT INTO Tab(Num) VALUES(@Num)
SET @ID=@@IDENTITY