Using system date as default value

[Snaggs]

I'm a newbie to SQL server. I have a table that has two fields in it. One is a date field the other is a Value field. I want a default value of the server date to be in the datestamp field when a new record is inserted.

Trigger? Stored Proc? Default Value?

This is an easy one I'm sure... But I know very little about SQL Server 2000.

Thanks, Snaggs
tribesaddict@swbell.net
Life can only be understood backwards; but it must be lived forwards.

 

[Andel]

You can use GETDATE() as the default value of your datestamp field.




Andel
andel@barroga.net

http://andyb.8m.com

 

[Snaggs]

Thanks, just didn't know what the function name was or what the syntax was.

Thanks again, Snaggs
tribesaddict@swbell.net
Life can only be understood backwards; but it must be lived forwards.