数据库编程的错误处理

BEGIN try
Create table OurIfTest
(
col1 int primary key
)
end try
begin catch
declare @errorNo int,
@severity tinyint,
@state smallint,
@lineNo int,
@message nvarchar(4000)
select 
@errorNo=ERROR_NUMBER(),
@severity=ERROR_SEVERITY(),
@state=ERROR_STATE(),
@lineNo=ERROR_LINE(),
@message=ERROR_MESSAGE()
IF @errorNo=2714
print 'already exits table'
else    
raiserror(@message,16,1)
end catch

 

posted @ 2013-05-03 10:57  viola  阅读(156)  评论(0编辑  收藏  举报