Answers for "try except sql"

SQL
0

sql try catch

BEGIN TRY
  SELECT 1 / 0 AS Error;
END TRY
BEGIN CATCH
  SELECT
    ERROR_NUMBER() AS ErrorNumber,
    ERROR_STATE() AS ErrorState,
    ERROR_SEVERITY() AS ErrorSeverity,
    ERROR_PROCEDURE() AS ErrorProcedure,
    ERROR_LINE() AS ErrorLine,
    ERROR_MESSAGE() AS ErrorMessage;
END CATCH;
Posted by: Guest on July-09-2021
0

except in sql

SELECT id, name, category, price FROM Books1
Except
SELECT id, name, category, price FROM Books2;
Posted by: Guest on April-17-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language