Add automatically maintained columns (perhaps just update_date, update_user) - by Louis Davidson

Status : 

  Postponed<br /><br />
		Due to current priorities, the product team decided to postpone the resolution of this item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


42
0
Sign in
to vote
ID 203570 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 9/15/2006 7:23:13 AM
Access Restriction Public

Description

A thing that I constantly have to use triggers for is automatically maintained columns, particularly for the update_date of a row.  Adding a default like constraint that automatically sets a column to a value would be an excellent change.   (No idea if the SQL spec allows for such things of course :)
Sign in to post a comment.
Posted by Rob Farley on 8/2/2009 at 8:42 PM
This would also be very useful for allowing this functionality without needing an OUTPUT-clause-breaking trigger.
Posted by Microsoft on 10/2/2006 at 10:50 AM
Hi,

Thank you for bringing this suggestion to our attention. While it does not meet the criteria for being included in SP2, we believe this is a useful feature and will consider it for future SQL Server releases.

Regards,
Tomer Verona
SQL Server Development