When writing a program in SQL, how do you handle error? For example, similar to the on error goto err in vb?

3ku_xyw

When writing a program in SQL, how do you handle error? For example, similar to the on error goto err in vb?
Write a stored procedure, how to handle error? There is no similar on error statement?

charrrr

@@ error

fanfan1980

GOTO
Change execution flow to label.

3ku_xyw

It feels that the stored procedure in SQL, the syntax is not a facet object, do you think?
I don't know how SQL2005 has progressed in this regard, it has never been used.

djazrael

USE pubs
GO
DECLARE @tablename sysname
SET @tablename = N'authors'
table_loop:
   IF (@@ FETCH_STATUS <> -2)
   BEGIN
      SELECT @tablename = RTRIM (UPPER (@tablename))
      EXEC ("SELECT" "" + @tablename + "" "= COUNT (*) FROM"
            + @tablename)
      PRINT ""
   END
   FETCH NEXT FROM tnames_cursor INTO @tablename
IF (@@ FETCH_STATUS <> -1) GOTO table_loop
GO

muyizouzhao

@Error in SQL Server to determine if it is abnormal
E.g:
insert into table1 (a, b) select 'aaa', 'bbbb'
if @@ error <> 0 goto err

return 0

err:
  return 1