我用下列代码创建存储过程失败。报出错误：“错误137：必须声明变量'@'”
请高手解答！！！

CREATE PROCEDURE SelRoom
@RoomType char(2),
@RoomPrice smallmoney OUTPUT
AS
SELECT rNum FROM tblRoom
WHERE(rType=@RoomType)AND(rStats='N')
SELECT @ RoomPrice=rprice FROM tblRoomType
WHERE rType = @RoomType
GO

CREATE PROCEDURE SelRoom
@RoomType char(2),
@RoomPrice smallmoney OUTPUT
AS
SELECT rNum FROM tblRoom
WHERE(rType=@RoomType)AND(rStats='N')
SELECT @ RoomPrice=rprice FROM tblRoomType
WHERE rType = @RoomType
GO
看看你得问题所在!

找到了，select @ 是什么意思啊？就是这里不行

[此贴子已经被作者于2005-12-6 10:51:19编辑过]

不错,看出问题以后应该善于总结,我们大家都需要经常总结啊!~