QUOTE(PsychoCoder @ 5 May, 2008 - 06:36 PM)
If you want it to default to the current date, in Enterprise Manager where it says Default Value for that column in that table (right click on the table and select Design) then select that column, down below will be a Default Value section, add GETDATE() on that line.
Thanks for that I knew it was somthing simple.
how would I query the db to see if the user id is already in the DB ?
Is there a way to run aselect statement that will output to a text file or even better an email with the results and a way of flagging the DB so if a user details have been stored or sent it will not send them again
somthing like
select email/date from Users where date > 4400
not sure if this is a VB or sql question sorry
thanks
This post has been edited by MIKE2098: 6 May, 2008 - 01:37 AM
5 May, 2008 - 04:54 AM
|