PeopleSoft Technologies
Wednesday, November 11, 2015
Writing Exception Handling for Select statement in SQL Server
BEGIN TRY INSERT INTO #VIEWCOUNT EXEC SP_EXECUTESQL N'SELECT ''TABELENAME'',COUNT(*) FROM TABLENAME'; END TRY BEGIN CATCH INSERT INTO #ERRORRECORD VALUES('TABLENAME'); END CATCH
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment