DoDolock

DECLARE @Tries tinyint
SET @Tries = 1
WHILE @Tries <= 3

BEGIN
BEGIN TRANSACTION
BEGIN TRY

/*

--在這裡放入將要執行的語法

*/

COMMIT
BREAK
END TRY

BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber
ROLLBACK
SET @Tries = @Tries + 1
CONTINUE
END CATCH

END

# posted by ken @ 11:25 上午