Compare Page Revisions
« Older Revision - Back to Page History - Newer Revision »
See:Dick:and:Jane:run
declare @Input varchar(500) ,@doc xml select @Input = 'See:Dick:and:Jane:run' ,@doc = convert(xml, '<x v="' + replace(@Input, ':', '"/><x v="') + '"/>') select v = T.c.value('.', 'varchar(100)') from @doc.nodes('x/@v') T(c)
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.