sending email verification link with database updation

[Smadhu]

i have popup on my webform with name and email id submit button,So when u click on submit button the name n email is entered into SQLSERVER database.
As user click on submit a verification link should be sent to him
table named "SUBSCRIBE" in database having columns :Name,Email,DateTime,Validated,ValidationEmailSent,Validation code
where name n email will come from as user entered....but others has to b generated
where validation=if clicked on link den 1 otherwise 0;
validation Email = if email id is proper value is 1 not proper value should be 0;
validation code is ramdom no;
values of this 3 columns will b updated in database as per user response.
How to write code for this problem as i have never used database sql server???

[GremlinSA]

Most of the Validating needs to be done in your code and not the SQL server.. (SQL stores the data and does only simple verification..

for validating the Email research Regular expressions...

Random Numbers look up RND()..
and the validated column would only be set if the linked URL Parameters match the Email/Username and the Random No...