事务错误
CREATE PROCEDURE INSERT_USER_DETAIL
@User_Name Varchar(20),@User_Passwd Varchar(20),@User_Company Varchar(40),@User_Question Varchar(40),@User_Answer
Varchar(40),@User_Addr Varchar(100),@User_Contact Varchar(20),@User_Tel Varchar(40),@User_Mail Varchar(40),@User_Fax Varchar(40),@User_Int Varchar(50),@User_Email Varchar(50),@User_Detail Varchar(1000),@User_Pro Varchar(1000)
As
BEGIN TRANSACTION
UPDATE User
SET User_Name=@User_Name,User_Passwd=@User_Passwd,User_Company=@User_Company,User_Question=@User_Question,User_Answer=@User_Answer,
User_Addr=@User_Addr,User_Contact=@User_Contact,User_Tel=@User_Tel,User_Mail=@User_Mail,User_Fax=@User_Fax,User_Int=@User_Int,User_Email=@User_Email,User_Detail=@User_Detail,User_Pro=@User_Pro
if (@@ERROR<>0)
Rollback TRANSACTION
else
COMMIT TRANSACTION
服务器: 消息 156，级别 15，状态 1，过程 INSERT_USER_DETAIL，行 6
在关键字 'User' 附近有语法错误。
问题点数：0、回复次数：2Top
1 楼pengdali（）回复于 2003-11-01 13:39:54 得分 0
CREATE PROCEDURE INSERT_USER_DETAIL
@User_Name Varchar(20),@User_Passwd Varchar(20),@User_Company Varchar(40),@User_Question Varchar(40),@User_Answer
Varchar(40),@User_Addr Varchar(100),@User_Contact Varchar(20),@User_Tel Varchar(40),@User_Mail Varchar(40),@User_Fax Varchar(40),@User_Int Varchar(50),@User_Email Varchar(50),@User_Detail Varchar(1000),@User_Pro Varchar(1000)
As
BEGIN TRANSACTION
UPDATE [User]
SET User_Name=@User_Name,User_Passwd=@User_Passwd,User_Company=@User_Company,User_Question=@User_Question,User_Answer=@User_Answer,
User_Addr=@User_Addr,User_Contact=@User_Contact,User_Tel=@User_Tel,User_Mail=@User_Mail,User_Fax=@User_Fax,User_Int=@User_Int,User_Email=@User_Email,User_Detail=@User_Detail,User_Pro=@User_Pro
if (@@ERROR<>0)
Rollback TRANSACTION
else
COMMIT TRANSACTION
Top
2 楼txlicenhe（马可）回复于 2003-11-01 13:43:27 得分 0
user --> [user]
Top
