Observing line numbers in exceptions : ERROR « System Settings « SQL Server / T-SQL Tutorial






6> SELECT 1
7> GO

-----------
          1

(1 rows affected)
1> SELECT 2
2> GO

-----------
          2

(1 rows affected)
1> SELECT 1/0
2> GO
Msg 8134, Level 16, State 1, Server J\SQLEXPRESS, Line 1
Divide by zero error encountered.
1>
2>








26.6.ERROR
26.6.1.@@error is
26.6.2.Using @@ERROR
26.6.3.@@ERROR reset
26.6.4.SELECT 5 / 0
26.6.5.SELECT * FROM master.dbo.sysmessages WHERE error = @@ERROR
26.6.6.Attempt to Capture @@IDENTITY, @@ROWCOUNT, and @@ERROR
26.6.7.Parse exception
26.6.8.connection-level exception
26.6.9.Check the @@ERROR with if statement
26.6.10.A stored procedure that uses the @@ERROR system function
26.6.11.Observing line numbers in exceptions