高手进来！！！快！！！！

[liuyong13145]

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???

[SQL77]

CREATE PROCEDURE bbb
@bbno VARchar(10),
@bbname VARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno

[百年树人]

declare @bbname char(10)
exec bbb '01',@bbname output
select @bbname

[baizhongxdy]

CREATE PROCEDURE bbb
@bbno VARchar(10),
@bbname VARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno

[liuyong13145]

[Quote=引用 2 楼 josy 的回复:]
SQL codedeclare@bbnamechar(10)exec bbb'01',@bbname outputselect@bbname
[/Quote]

这位写的代码虽然能有，可能太烦了吧，那么这个存储过程写了有什么用呢？？

[华夏小卒]

--> 测试数据:  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 行受影响)

[SQL77]

[Quote=引用 1 楼 sql77 的回复:]
CREATE PROCEDURE bbb
@bbno VARchar(10),
@bbnameVARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno
[/Quote]

你的能输出正确的么?

最好要用VARCHAR(10)

要结果用树哥的

[liuyong13145]

[Quote=引用 3 楼 baizhongxdy 的回复:]
CREATE PROCEDURE bbb
@bbno VARchar(10),
@bbname VARchar(10) output
AS
SELECT @bbname=bname
FROM b
WHERE bno=@bbno
[/Quote]

这个代码有用吗？？？

[liuyong13145]

35）在web站点上，如果知道一个人的email id，则人们可以搜索一个人的地址和电话号码。接受某人的email id和返回其地址和电话号码的过程创建如下：
CREATE PROCEDURE prcGetAddress
@EmailId char(30),
@Address char(30) output,
@Phone char(15) output,
AS
SELECT @Address=cAddress, @Phone = cPhone
FROM Subscriber
WHERE cEmailId=@EmailId
你可用以下过程中哪一个，它用上面过程来接受email id和显示其地址和电话号码？
[3分]
1.CREATE PROCEDURE prcDisplayAddress
@Email char(30)
AS
DECLARE @Address char(50) OUTPUT, @Phone char(15) OUTPUT
EXEC prcGetAddress @Email, @Address, @Phone
SELECT @Address, @Phone
RETURN
2.CREATE PROCEDURE prcDisplayAddress
@Email char(30)
AS
DECLARE @Address char(50), @Phone char(15)
EXEC prcGetAddress @Email, @Address , @Phone
SELECT @Address, @Phone
RETURN
3.CREATE PROCEDURE prcDisplayAddress
@Email char(30)
AS
DECLARE @Address char(50), @Phone char(15)
SELECT @Address, @Phone
RETURN
4.CREATE PROCEDURE prcDisplayAddress
@Email char(30)
AS
DECLARE @Address char(50), @Phone char(15)
EXEC prcGetAddress @Email, @Address OUTPUT, @Phone OUTPUT
SELECT @Address, @Phone
RETURN