Parse exception : ERROR « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. ERROR
3> SELECTxzy FROM SomeTable
4> PRINT 'This will NOT print!'
5> GO
Msg 156, Level 15, State 1, Server J\SQLEXPRESS, Line 3
Incorrect syntax near the keyword 'FROM'.
1>








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