sql query in the sql server

Question

I have a login page on which are userid and password feeld, but I want to write the query for login when user can give username or emailid in userid textbox.

Answer 1

That's a bit too vague. If you are just starting out, I'd recommend you look at the login control. You could use this in conjunction with the SQL Server Membership provider and not have to write any SQL yourself.