事务错误

Question

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