Question: how to convert sql server data to xml?
Answer: DECLARE @EXAMPLE TABLE.
(
ID INT,
Name VARCHAR(50)
)
INSERT INTO @EXAMPLE VALUES.
(1, 'C#1'),
(2, 'C#2'),