-- ¿øº» ¸µÅ© http://purumae.tistory.com/178 DECLARE @vchString varchar(max), @vchDelimiter varchar(10); -- ÄÞ¸¶·Î ±¸ºÐµÈ ¹®ÀÚ¿­ SELECT @vchString = '¸Þ·Õ1, ¸Þ·Õ2, ¸Þ·Õ3', @vchDelimiter = ','; DECLARE @xmlString xml, @xmlSQL VARCHAR(MAX); SET @xmlSQL = N''; SELECT @xmlString = CAST(@xmlSQL AS XML); -- XML DATA SELECT @xmlString; -- ±¸ºÐÇÒ ¼ö ÀÖ´Â ¹®ÀÚ¿­ÀÌ Á¤ÇØÁú °æ¿ì ¾Æ·¡ÀÇ ¹æ¹ýÀº ¾î¶°ÇÑÁã~? SELECT @xmlString.value('(Property/X/@n)[1]', 'varchar(8000)') AS n1 -- data type¿¡ ¸Â°Ô varchar(8000)À» ¼öÁ¤ ÇÑ´Ù^^ ,@xmlString.value('(Property/X/@n)[2]', 'varchar(8000)') AS n2 ,@xmlString.value('(Property/X/@n)[3]', 'varchar(8000)') AS n3