ALTER TABLE [dbo].[Emp] add eee varchar(10) null constraint df_eee default ''; GO update [dbo].[Emp] set eee='12'