alter procedure testexception
as
declare @date datetime;
begin
begin try
set @date=cast('200012' as datetime);
select @date;
end try
begin catch
select * from master.dbo.sysmessages where [error] = @@error;
end catch
end;
转载于:https://www.cnblogs.com/baishahe/archive/2010/01/06/1640608.html