Posted by Chandra on 06/09/05 07:02

alternatively, you can also use as

ALTER TABLE your_table ADD date_created DATETIME NOT NULL
CONSTRAINT df_your_table_date_created DEFAULT getdate()


best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: sql server jobs with good salary
• Prev in forum: Re: Does the transaction log on a publisher SQL server get truncated when the database is backed up, but the distributor is down?
• Thread view: Re: Date/Time Stamp

[Reply to this message]