-
New features/functionality/tools/etc
Hi,
Anyone interested in discussing new things in Yucon......
I will start...........
Error handling .........this is going to be very very useful & tricky
USE master
TRY
BEGIN TRY
declare @a nvarchar(100)
set @a='sysobjects'
declare @sqlstr nvarchar(100)
set @sqlstr = 'select top 1 * from ' + @a
exec sp_executesql @sqlstr
print 'here'
SELECT 1/0;--error
END TRY
CATCH
BEGIN CATCH
SELECT ERROR_LINE() AS ErrorLine;
SELECT ERROR_MESSAGE() AS ErrorMessage;
print 'here'
END CATCH
select top 1 * from sysobjects
GO
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|