By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TableA
(
ID INT IDENTITY (1,1),
TestData VARCHAR(120)
);
INSERT TableA Select 'A';
INSERT TableA Select 'B';
INSERT TableA Select 'C';
SELECT
*
FROM
TableA;
| ID | TestData |
|---|---|
| 1 | A |
| 2 | B |
| 3 | C |
ALTER TABLE TableA ADD [Field1] [xml] DEFAULT
CAST(N'<SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" />' AS xml)
ALTER TABLE TableA ADD [Field2] [xml] DEFAULT
CAST(N'<SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" />' AS xml) WITH VALUES
ALTER TABLE TableA ADD [Field3] [xml] NOT NULL DEFAULT
CAST(N'<SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" />' AS xml)
SELECT * from TABLEA
| ID | TestData | Field1 | Field2 | Field3 |
|---|---|---|---|---|
| 1 | A | null | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> |
| 2 | B | null | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> |
| 3 | C | null | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> | <SettingValues xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://someurl.com/schemas.xsd" /> |