Default a field value in SQL Server

We initialise a field`s value in D365FO / Ax2012 …. (I am saying this as an example since I am from Technical Ax background ) . Similarly, we can also initialise a columns`s value in SQL Server.

Use this simple command

ALTER TABLE TableName ADD DEFAULT ('DefaultValue') FOR FieldName

Example :

ALTER TABLE workers ADD DEFAULT ('Ready') FOR ExportStatus

To check if a…

Continue Reading AnithaEswaran’s Article on their blog

Blog Syndicated with AnithaEswaran’s Permission

Author: Anitha Santosh

Share This Post On