2012年5月10日 星期四

MS SQL TRY CATCH

參考:
Handling Errors With SQL Server 2005's TRY...CATCH Blocks
TRY CATCH 陳述式

用法:
BEGIN TRY
Try Statement 1
Try Statement 2
...
Try Statement M
END TRY
BEGIN CATCH
Catch Statement 1
Catch Statement 2
...
Catch Statement N
END CATCH


Take a look at below example,
BEGIN TRY
SELECT GETDATE()
SELECT 1/0--Evergreen divide by zero example!
END TRY
BEGIN CATCH
SELECT 'There was an error! ' + ERROR_MESSAGE()
RETURN
END CATCH;

沒有留言:

張貼留言