text: ﻿CREATE PROCEDURE [dbo].[spAdmin_DeleteById.sql]
  	@inId INT
  AS
  BEGIN
  	SET NOCOUNT ON;		-- don't give how many rows affected
  
  	IF EXISTS (SELECT * FROM [tblAdmin] WHERE Id = @inId)
  	BEGIN;
  		DELETE FROM [tblAdmin] WHERE Id = @inId;
  	END
  	ELSE
  	BEGIN;
  	   -- We tried to delete a row that didn't exist
  	   THROW 50000, 'Tried deleting row that did not exist', 1;
  	END
  
  END
  RETURN 0
  