34,576
社区成员
发帖
与我相关
我的任务
分享
USE tempdb;
GO
IF OBJECT_ID('a') IS NOT NULL
DROP TABLE a;
GO
--创建表a
CREATE TABLE a
(a1 INT ,
a2 INT );
GO
--插入数据
INSERT INTO a VALUES (1,1);
INSERT INTO a VALUES (2,2);
INSERT INTO a VALUES (3,3);
INSERT INTO a VALUES (4,4);
INSERT INTO a VALUES (5,5);
GO
IF OBJECT_ID('spa') IS NOT NULL
DROP PROCEDURE spa;
GO
--创建spa过程
CREATE PROCEDURE spa
@a1 INT OUTPUT ,
@a2 INT OUTPUT
AS
BEGIN
SELECT @a1=a1,@a2=a2 FROM a;
END;
GO
--调用过程
DECLARE @a1 INT ,
@a2 INT
EXEC spa @a1 OUTPUT ,@a2 OUTPUT ;
SELECT @a1,@a2;
--结果显示
(无列名) (无列名)
5 5
IF OBJECT_ID('spa') IS NOT NULL
DROP PROCEDURE spa;
GO
--创建spa过程
CREATE PROCEDURE spa
AS
BEGIN
SELECT a1,a2 FROM a;
END;
exec spa