by Ander » Sat, 25 Sep 1999 04:00:00
would like to have a table for logging information where I don't write
the two first columns: an autoincremental col(PK) and a timestamp.
TIA/anders
by Mladen Tur » Sat, 25 Sep 1999 04:00:00
Anders,Quote:> is it possible to create a table where one field is automatically set
> to the current date/time of the server, like a default value ?
> would like to have a table for logging information where I don't write
> the two first columns: an autoincremental col(PK) and a timestamp.
> TIA/anders
by Ander » Sat, 25 Sep 1999 04:00:00
Fri, 24 Sep 1999 18:10:58 +0200, "Mladen Turk"
;CURRENT_TIMESTAMP
by Tibor Karasz » Tue, 28 Sep 1999 04:00:00
Most people prefer to use the IDENTITY property instead of the
uniqueidentifier datatype.
--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
Quote:> is it possible to create a table where one field is automatically set
> to the current date/time of the server, like a default value ?
> would like to have a table for logging information where I don't write
> the two first columns: an autoincremental col(PK) and a timestamp.
> TIA/anders
1. Current date and time as the Default Value for a DateTime Field
Hello all.
Is there a way to have the system date and time entered into a datetime
field when the record is entered into the table?
I see the Default Value column, but what would I enter there to get this to
work?
Thx,
Scott Buerkley
2. Help!
3. Current date as default-value
5. current value of default value in column?
7. MYSQL - DEFAULT DATE as CURRENT DATE
8. Borland C++ and WATCOM SQL for DOS
9. default datestamp of 12am of today's date for default value
10. Current Date default param in stored proc
12. ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt
13. Testing if Time.Current member is greater than a date value