Hello
I try to write all SQL as Stored Procedures.
When I tried to write a SP with Parameters:

CREATE PROCEDURE dbo.Hot AS
select Email
from Member
where email = @email
go

I get error: @email is not declared.

Can I write such SP only in aspx where I can declare it?????

ASPX issues aside, you first need to write the SQL procedure correctly:

CREATE PROCEDURE dbo.Hot @email VARCHAR(255)
AS
    select Email
    from Member
    where email = @email
GO