sql 常用语法,事务处理

1.sql事务处理

BEGIN TRY
	BEGIN TRANSACTION
    /*默认走这里*/
	DECLARE @rkey INT /*定义变量,用于存储插入数据的rkey*/
	INSERT INTO ws_test (userName,age,createDate) VALUES ('周瑜',18,GETDATE())
	SET @rkey = SCOPE_IDENTITY() /*这里获取rkey*/
	UPDATE ws_test SET age = 4000 WHERE rkey = @rkey  /*这里使用rkey*/
	
	COMMIT TRANSACTION
END TRY
BEGIN CATCH 
    /*出错走这里*/
	ROLLBACK TRANSACTION  /*回滚上面的操作*/
    /*返回错误信息*/
	SELECT ERROR_MESSAGE() AS ErrorMessage,ERROR_SEVERITY() AS ErrorSeverity,ERROR_STATE() AS ErrorState  
END CATCH