check user already in Database before insert new user

[truonglv]

I'm writing a register page use ASP (javascript) and Microsoft SQL Server 2000, but I don't know to check user (username and email) already in database before insert new user (my database is Customers).

Please help me code for this.

Thanks.

 

[gmmastros]

What have you tried so far?

-George

"the screen with the little boxes in the window." - Moron

 

[Sheco]

If your T-SQL skills are better than your ASP, perhaps a single stored procedure would be the easiest way to do it. The logic could first query for a match and then conditionally INSERT or UPDATE depending on the query results.