Trying to execute a stored procedure and getting an error

[Ken Bond]

I'm trying to execute a simple stored procedure that will count and display the number of customers in my Customer table that have a phone number listing. I get the error "1064(42000). You have an error in your SQL syntax".

CREATE PROCEDURE CountPhoneNumbers
AS
DECLARE @count INTEGER
SELECT @count = COUNT (*)
FROM Customer
WHERE HomePhone IS NOT NULL
Print @count
EXECUTE CountPhoneNumbers;