sqlserver 預存程序樣本

USE [ch06]<br />GO<br />/****** 對象: StoredProcedure [dbo].[p_Transfer] 指令碼日期: 09/24/2009 11:26:46 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />ALTER procedure [dbo].[p_Transfer](<br /> @money int<br />)<br />as<br />BEGIN TRY<br /> begin tran t1;<br /> -- insert into t_Account(aa)values('dsdds');<br />update t_Account<br />set balance = balance -@money<br />where id = 1;<br />update t_Account<br />set balance = balance + @money<br />where id = 2;<br /> commit tran t1;<br />END TRY<br />BEGIN CATCH<br /> rollback;<br /> SELECT<br /> ERROR_NUMBER() AS ErrorNumber,<br /> ERROR_MESSAGE() AS ErrorMessage;<br />END CATCH;