XML.sql

CREATE PROC [dbo].[usp_InsertDemoXML] @xmlBin AS varbinary(max)
AS
BEGIN
	declare @xml xml = convert(xml,@xmlBin) 
	INSERT INTO Demo ([Key],[Value]) 
	SELECT 
		[key]	= x.v.value('key[1]','int'), 
		[Value] = x.v.value('value[1]','varchar(50)')  
	FROM @xml.nodes('/table/row') x(v)
END