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.

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


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

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.

Tomer Verona
SQL Server Development