SQL Server equivalent of Oracle’s “when no data found” exception

Question

I need SQL Server equivalent of Oracle’s “when no data found” exception example:

EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         RETURN 0;
      WHEN OTHERS
      THEN
         RETURN 0;

converter to sql server

Answer 1

DECLARE @rc INT = 1
IF NOT EXISTS(SELECT * FROM table WHERE ...) SET @rc = 0
RETURN @rc

Answer 2

If you really need to use exception handling then you can do the following:

BEGIN TRY
  /* your other code */

  IF NOT EXISTS(SELECT * FROM table WHERE [...])
    THROW 50000, 'Your error messages here!', 1
  
  /* more code */
END TRY
BEGIN CATCH
  /* exception handling goes here */
END CATCH

If not, the you can just use IF NOT EXISTS (SELECT * FROM blah)