create proc bbb @a int, @a1 int output, @b datetime output, @c varchar(8) output as select @a1=aa,@b=b,@c=c from a where aa=@a===测试该存储过程: declare @a1 int,@b datetime,@c varchar(8) exec bbb 1,@a1 output,@b output,@c output select @a1 a ,@b b ,@c c --不知这是不是你想要实现的效果
--建立测试环境create table a (aa int,b datetime,c varchar(8)) insert a values (1,'2001-01-05','aaa') insert a values (2,'2001-01-04','a1a') insert a values (3,'2001-01-05','a5a') insert a values (6,'2001-01-07','a3a') insert a values (4,'2001-01-10','a2aa') insert a values (5,'2001-01-15','a1a')---创建存储过程; create proc bbb @a int, @a1 int output, @b datetime output, @c varchar(8) output as select @a1=aa,@b=b,@c=c from a where aa=@a---测试存储过程 declare @a1 int,@b datetime,@c varchar(8) exec bbb 1,@a1 output,@b output,@c output select @a1 a ,@b b ,@c c ----删除测试环境 drop table a
create proc bbb
@a int,
@a1 int output,
@b datetime output,
@c varchar(8) output
as
select @a1=aa,@b=b,@c=c from a where aa=@a===测试该存储过程:
declare @a1 int,@b datetime,@c varchar(8)
exec bbb 1,@a1 output,@b output,@c output
select @a1 a ,@b b ,@c c
--不知这是不是你想要实现的效果
insert a values (1,'2001-01-05','aaa')
insert a values (2,'2001-01-04','a1a')
insert a values (3,'2001-01-05','a5a')
insert a values (6,'2001-01-07','a3a')
insert a values (4,'2001-01-10','a2aa')
insert a values (5,'2001-01-15','a1a')---创建存储过程;
create proc bbb
@a int,
@a1 int output,
@b datetime output,
@c varchar(8) output
as
select @a1=aa,@b=b,@c=c from a where aa=@a---测试存储过程
declare @a1 int,@b datetime,@c varchar(8)
exec bbb 1,@a1 output,@b output,@c output
select @a1 a ,@b b ,@c c ----删除测试环境
drop table a