select * from b
显示如下结果!
bno bname
01 jacd
02 jacdd
04 jacdeef 然后我创建如下的存储过程CREATE PROCEDURE bbb
@bbno char(10),
@bbname char(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno执行成功后,我怎么显示结果????怎么显示输出的bname???
显示如下结果!
bno bname
01 jacd
02 jacdd
04 jacdeef 然后我创建如下的存储过程CREATE PROCEDURE bbb
@bbno char(10),
@bbname char(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno执行成功后,我怎么显示结果????怎么显示输出的bname???
@bbno VARchar(10),
@bbname VARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno
exec bbb '01',@bbname output
select @bbname
@bbno VARchar(10),
@bbname VARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno
--> 测试数据: tb
if object_id('b') is not null drop table b
go
create table b (bno varchar(2),bname varchar(7))
insert into b
select '01','jacd' union all
select '02','jacdd' union all
select '04','jacdeef'
if object_id('bbb') is not null drop proc bbb
go
CREATE PROCEDURE bbb
@bbno char(10),
@bbname char(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno
go declare @s char(10)
exec bbb '01' , @s output select @s
----------
jacd (1 行受影响)
你的能输出正确的么?最好要用VARCHAR(10)要结果用树哥的