If there is no default value for the column then you can use this query: ALTER TABLE MyTable ADD CONSTRAINT df_MyTable_MyColumn DEFAULT 0 FOR MyColumn
Tag: default value
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (831)
- Get the First and Last Word from a String or Sentence in SQL (745)
- How to select distinct rows in a datatable in C# (682)
- How to add default value for Entity Framework migrations for DateTime and Bool (570)
- Add Constraint to SQL Table to ensure email contains @ (512)