JBTALKS.CC

标题: SQL储存过程出错，大大来帮忙 [打印本页]

作者: ranplayer 时间: 2011-4-4 04:28 PM
标题: SQL储存过程出错，大大来帮忙
存储过程是这个代码

CREATE PROCEDURE sp_InsertUserLastInfo
@Num int,
@money varchar
AS
   DECLARE
   @Level int
SET NOCOUNT ON
SET @level=0
SELECT @level=ChaLevel FROM ChaInfo WHERE UserNum=@Num
   IF @level<>0
      BEGIN
      INSERT INTO ChaLastInfo(ChaNum,ChaLevel,ChaMoney) VALUES (@Num,@level,@money)
      END
SET NOCOUNT OFF
go

错误是未能准备语句

请问要如何处理? 我也不太会，是帮朋友问的..请大大指教谢谢!

欢迎光临 JBTALKS.CC (https://www.jbtalks.cc/)