Return to Question

		Post Closed as "Duplicate of…" by Paul White says GoFundMonica♦, Aaron Bertrand♦ of Adding columns to production tables	occurred Jan 2 '15 at 14:14

	3	edited tags \| link	edited Jan 2 '15 at 13:36 Paul White says GoFundMonica♦ 50.2k16 gold badges314 silver badges495 bronze badges
sql-server sql table sql-server-2008-r2 ddl

	2	tagged sql-server. Formatted error source \| link	edited Jan 2 '15 at 13:21 Mark Sinkinson 8,8543 gold badges31 silver badges50 bronze badges
inline side-by-side side-by-side markdown I have a existing table in which i am adding a column as `NgoId` whose datatype is `int`. I want to add as `NOT NULL` to the column . When I mI'm adding this I am getting the following error as: Unable to modify table. Cannot insert the value NULL into column 'NgoId', table 'CSR.dbo.Tmp_tbl_post_category'; column does not allow nulls. INSERT fails. The statement has been terminated. * Unable to modify table. Cannot insert the value NULL into column 'NgoId', table 'CSR.dbo.Tmp_tbl_post_category'; column does not allow nulls. INSERT fails. The statement has been terminated. Please help how to add the column with NOT NULL. I have a existing table in which i am adding a column as `NgoId` whose datatype is `int`. I want to add as `NOT NULL` to the column . When I m adding this I am getting error as Unable to modify table. Cannot insert the value NULL into column 'NgoId', table 'CSR.dbo.Tmp_tbl_post_category'; column does not allow nulls. INSERT fails. The statement has been terminated. * Please help how to add the column with NOT NULL. I have a existing table in which i am adding a column as `NgoId` whose datatype is `int`. I want to add as `NOT NULL` to the column . When I'm adding this I am getting the following error: Unable to modify table. Cannot insert the value NULL into column 'NgoId', table 'CSR.dbo.Tmp_tbl_post_category'; column does not allow nulls. INSERT fails. The statement has been terminated. Please help how to add the column with NOT NULL. sql-server sql table

	1	source \| link	asked Jan 2 '15 at 13:14 hud bhaisahab 1812 gold badges5 silver badges18 bronze badges
Add a column with Not Null I have a existing table in which i am adding a column as `NgoId` whose datatype is `int`. I want to add as `NOT NULL` to the column . When I m adding this I am getting error as Unable to modify table. Cannot insert the value NULL into column 'NgoId', table 'CSR.dbo.Tmp_tbl_post_category'; column does not allow nulls. INSERT fails. The statement has been terminated. * Please help how to add the column with NOT NULL. sql table

Database Administrators Stack Exchange works best with JavaScript enabled