CODE EXAMPLE FOR SQL

create procedure with encryption

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