Analysis of SQL stored procedures and transaction processing

In database programming, transactions are frequently used. net platform, transaction processing is very easy to use, but in the stored procedures of SQL Server database, how to use transactions to complete data batch operations?

The solution is as follows:
Copy codeThe Code is as follows:
Create proc RegisterUser
(@ UsrName varchar (30), @ usrPasswd varchar (30), @ age int, @ PhoneNum varchar (20), @ Address varchar (50 ))
AS
BEGIN

Begin tran -- display the definition and start a transaction
SET XACT_ABORT ON -- indicates rolling back immediately when an error occurs.

Insert into user (userName, userPasswd) values (@ usrName, @ usrPasswd)

IF @ error <> 0 -- an error occurs.
BEGIN
ROLLBACK TRANSACTION
RETURN 0
END
ELSE
BEGIN
COMMIT TRANSACTION
RETURN 1 -- execution successful
END

END

Concise enough!