--NB CREATE PROCEDURE MUST be the FIRST/ONLY statement in this query batch

--CREATE PROCEDURE usp_TotalRowCount
--AS
--DECLARE @Count AS INTEGER
--SELECT @Count = COUNT(*)
--FROM Customers
--WHERE cust_email IS NULL
--PRINT @Count

--Execute the user stored procedure
--EXEC usp_TotalRowCount

--SELECT *
--FROM Customers

----Drop the Procedure for testing purposes
--DROP PROCEDURE usp_TotalRowCount