sql server programming: SQL 2005 and DateTime fields -- sql server programming

SQL 2005 and DateTime fields

Ben Kim
9/7/2005 9:34:09 PM

sql server programming:

I am playing with the CTP if SQL 2005 and loving it. However I was under
the impression that this new SQL server version WOULD support separate date
and time fields. Is this planned as a last minute change before release?
Reasons to have separate DT fields:

1. Tracking dates where we could care less about the time.
2. Tracking time for items such as "fixed" employee schedules.

Also, I have not dug deep enough yet to find the answer, but will there be
or is there "Before" triggers? IE: Before SQL writes/updates/deletes a
record(set), can I act on this data to add additional elements or validate?

Ben

Re: SQL 2005 and DateTime fields

Aaron Bertrand [SQL Server MVP]
9/7/2005 10:44:21 PM

[quoted text, click to view]

No, it was dropped. Please ask SQL Server 2005 questions in the SQL Server
2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1

[quoted text, click to view]

Microsoft is well aware of the reasons for (and the customer demand for)
separate date and time data types. However, there were several roadblocks
and the functionality has been pushed to a future release.

[quoted text, click to view]

Check out "INSTEAD OF" triggers in Books Online. These are available
starting with SQL Server 2000.