[MS-SQL] FOR XML

개발자

[MS-SQL] FOR XML

zupper 2011. 6. 17. 23:30

FOR XML

[ZUPPER's Code]

SELECT SEQ, MENU_CODE, CONVERT(NVARCHAR(10),REG_DATE,102) REG_DATE FROM TAPRO_ACTION_LOG WHERE CONVERT(NVARCHAR(10),REG_DATE,120) = '2011-06-17' FOR XML RAW, ROOT('DataSet') -- 결과값 <DataSet> <row SEQ="4822" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4823" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4824" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4825" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4826" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4827" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4828" MENU_CODE="MN0020" REG_DATE="2011.06.17" /> <row SEQ="4829" MENU_CODE="MN0011" REG_DATE="2011.06.17" /> <row SEQ="4830" MENU_CODE="MN0021" REG_DATE="2011.06.17" /> <row SEQ="4831" MENU_CODE="MN0021" REG_DATE="2011.06.17" /> <row SEQ="4832" MENU_CODE="MN0021" REG_DATE="2011.06.17" /> <row SEQ="4833" MENU_CODE="MN0021" REG_DATE="2011.06.17" /> <row SEQ="4834" MENU_CODE="MN0015" REG_DATE="2011.06.17" /> <row SEQ="4835" MENU_CODE="MN0015" REG_DATE="2011.06.17" /> <row SEQ="4836" MENU_CODE="MN0078" REG_DATE="2011.06.17" /> <row SEQ="4837" MENU_CODE="MN0077" REG_DATE="2011.06.17" /> </DataSet> SELECT SEQ, MENU_CODE, CONVERT(NVARCHAR(10),REG_DATE,102) REG_DATE FROM TAPRO_ACTION_LOG WHERE CONVERT(NVARCHAR(10),REG_DATE,120) = '2011-06-17' FOR XML RAW, ELEMENTS, ROOT('MyRoot') ; <MyRoot> <row> <SEQ>4822</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4823</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4824</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4825</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4826</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4827</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4828</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4829</SEQ> <MENU_CODE>MN0011</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4830</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4831</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4832</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4833</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4834</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4835</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4836</SEQ> <MENU_CODE>MN0078</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4837</SEQ> <MENU_CODE>MN0077</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> </MyRoot> SELECT SEQ, MENU_CODE, CONVERT(NVARCHAR(10),REG_DATE,102) REG_DATE FROM TAPRO_ACTION_LOG WHERE CONVERT(NVARCHAR(10),REG_DATE,120) = '2011-06-17' FOR XML RAW, ELEMENTS; <row> <SEQ>4822</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4823</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4824</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4825</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4826</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4827</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4828</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4829</SEQ> <MENU_CODE>MN0011</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4830</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4831</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4832</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4833</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4834</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4835</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4836</SEQ> <MENU_CODE>MN0078</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row> <SEQ>4837</SEQ> <MENU_CODE>MN0077</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> SELECT SEQ, MENU_CODE, CONVERT(NVARCHAR(10),REG_DATE,102) REG_DATE FROM TAPRO_ACTION_LOG WHERE CONVERT(NVARCHAR(10),REG_DATE,120) = '2011-06-17' FOR XML RAW, ELEMENTS XSINIL ; <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4822</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4823</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4824</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4825</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4826</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4827</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4828</SEQ> <MENU_CODE>MN0020</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4829</SEQ> <MENU_CODE>MN0011</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4830</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4831</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4832</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4833</SEQ> <MENU_CODE>MN0021</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4834</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4835</SEQ> <MENU_CODE>MN0015</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4836</SEQ> <MENU_CODE>MN0078</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SEQ>4837</SEQ> <MENU_CODE>MN0077</MENU_CODE> <REG_DATE>2011.06.17</REG_DATE> </row>

저작자표시 (새창열림)