ranplayer
2011-4-4 04:28 PM
存储过程是这个代码
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
错误是 未能准备语句
请问要如何处理? 我也不太会，是帮朋友问的..请大大指教谢谢!
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
错误是 未能准备语句
请问要如何处理? 我也不太会，是帮朋友问的..请大大指教谢谢!
