Support for Non-deterministic expressions or functions, such as GETDATE() or CURRENT_TIMESTAMP in default constraints
Vishal Gupta commented
Need this feature for lot of auditing and migration activity !!!
Robert Kostecki commented
Must for any audit table ...
CREATE TABLE [Schema].[TableName]
[LoadTime] [datetime2] NOT NULL CONSTRAINT DF_TableName_LoadTime DEFAULT GETDATE(),
Jason Horner commented
Agreed this should support functions like SYSDATETIME() and SUSER_NAME() too
What a joke this is not available :-(
Anubhav Agarwal commented
Any update on this? Need to add a default column with the current system date
What can be the alternative for this if this is not supported?
Any valid timeline for this??