34,623
社区成员
发帖
与我相关
我的任务
分享有关procedure 的问题
创建一个删除学生的procedure,输入参数为学生的学号，现在想在完成
时输出“XX have dropped”的消息。如何实现？？？
create proc drop_student
(@parameter int,
@message char(30) output)
as
delete from student
where sno=@parameter;
delete from cs
where sno=@parameter
delete from other
where sno=@parameter
时输出“XX have dropped”的消息。如何实现？？？
create proc drop_student
(@parameter int,
@message char(30) output)
as
delete from student
where sno=@parameter;
delete from cs
where sno=@parameter
delete from other
where sno=@parameter
...全文
请发表友善的回复…
发表回复
gmlxf 2003-11-10
- 打赏
- 举报
print @message
pengdali 2003-11-10
- 打赏
- 举报
create proc drop_student
(@parameter int,
@message char(30) output)
as
delete from student where sno=@parameter;
delete from cs where sno=@parameter
delete from other where sno=@parameter
set @message=cast(@parameter as varchar(10))+' have dropped'
go
(@parameter int,
@message char(30) output)
as
delete from student where sno=@parameter;
delete from cs where sno=@parameter
delete from other where sno=@parameter
set @message=cast(@parameter as varchar(10))+' have dropped'
go
