clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335674 fiddles created (27443 in the last week).

create table T(ID int, X xml); insert into T(ID, X) values(1, '<X>1</X>'); insertt into T(ID, X) values(2, '<X>1</X>');
Line 4: Incorrect syntax near 'insertt'.
 hidden batch(es)


select T.ID, TX.X.value('text()[1]', 'int') as X from T cross apply T.X.nodes('X') as TX(X);
Line 1: Invalid object name 'T'.
 hidden batch(es)