sql set default value datetime now
snippet in sql

sql set default value datetime now

user9948

ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn