CREATE PROCEDURE spSomething @Gender nvarchar(5), @variable2 int output WITH ENCRYPTION AS BEGIN SELECT @Pcount = count(*) from MembersFromServer where Gender = @Gender END GO