Question : sql add column int nullable
Answered by : zohan3456
ALTER TABLE YourTable ADD Foo INT NULL /*Adds a new int column existing rows will be given a NULL value for the new column*/Source : https://stackoverflow.com/questions/5666126/add-column-to-sql-server | Last Update : Mon, 28 Feb 22
Question : sql - add not null column take values from other column
Answered by : belaid-nacereddine
-- add the column (as nullable)
alter table mytable add created_year int;
-- update the values on existing rows
update items set created_year = year(created_date);
-- make the column not nullable
alter table mytable alter column created_year int not null;Source : https://sqlerrors.com/howto/26768/sql---add-not-null-column-take-values-from-other-column | Last Update : Fri, 23 Sep 22
Question : add values of column with null sql
Answered by : jeremy-katz
SELECT sum(COALESCE(TotalHoursM,0)) + COALESCE(TotalHoursT,0) + COALESCE(TotalHoursW,0) + COALESCE(TotalHoursTH,0) + COALESCE(TotalHoursF,0) AS TOTAL FROM LeaveRequestSource : https://stackoverflow.com/questions/1088648/sql-sum-3-columns-when-one-column-has-a-null-value | Last Update : Mon, 19 Sep 22