Sunday, February 19, 2012

Date created defualt value

in my database i have a "datecreated" feild, its datatype is "datetime", is it possible to set the defualt value as the time now? if so what do I put in the defualt value property? thanks a million si!

Under design view for the Table, you can set he default value of "Getdate()" (without the quotes). You dont need to do anything from yout T-SQL or application. The value is automatically inserted by SQL Server.

|||

thanks a million! thats going to save sometimeBig Smile si!

No comments:

Post a Comment