Change a Nullable column to NOT NULL with Default Value

I think you will need to do this as three separate statements. I've been looking around and everything i've seen seems to suggest you can do it if you are adding a column, but not if you are altering one.

ALTER TABLE dbo.MyTableADD CONSTRAINT my_Con DEFAULT GETDATE() for createdUPDATE MyTable SET Created = GetDate() where Created IS NULLALTER TABLE dbo.MyTable ALTER COLUMN Created DATETIME NOT NULL 

You may have to first update all the records that are null to the default value then use the alter table statement.

Update dbo.TableNameSetCreated="01/01/2000"where Created is NULL

you need to execute two queries:

One - to add the default value to the column required

ALTER TABLE 'Table_Name` ADD DEFAULT 'value' FOR 'Column_Name'

i want add default value to Column IsDeleted as below:

Example: ALTER TABLE [dbo].[Employees] ADD Default 0 for IsDeleted

Two - to alter the column value nullable to not null

ALTER TABLE 'table_name' ALTER COLUMN 'column_name' 'data_type' NOT NULL

i want to make the column IsDeleted as not null

ALTER TABLE [dbo].[Employees] Alter Column IsDeleted BIT NOT NULL