default value besides 0? 2

[LikeThisName]

have a date field in sql server
want to set the default to today.
i can get today with vbscript when constructing an insert statement but i thought i should use the backend if possible to calculate today's date.

LikeThisName <- ? Sorry It's Taken =)

 

[amorous]

GetDate() will give you today's date.

-VJ

 

[TheBugSlayer]

Try
ALTER TABLE MyTable WITH NOCHECK ADD
CONSTRAINT DateColumnDflt DEFAULT (getdate()) FOR DateColumn

or add (getdate()) in the Default value property for the field in EM table designer.