출처 : <a href="http://www.sqler.com/bSQLQA/271870" target="_blank">http://www.sqler.com/bSQLQA/271870</a> 
 
 

select 'insert into [Table] Values (''' + col1 + ''',''' + col2 + ''',''' + col3 + ''');' <o:p></o:p>
from [Table] <o:p></o:p>
<o:p>&nbsp; 
 
 &nbsp;SELECT 'Insert into
[AUTH_GroupPermission] values (''' + GroupID + ''',''[<span style="mso-bidi-font-size:10.0pt;
mso-ascii-font-family:&quot;Courier New&quot;;mso-hansi-font-family:&quot;Courier New&quot;;
mso-bidi-font-family:&quot;Courier New&quot;;color:red;mso-font-kerning:0pt;mso-no-proof:
yes">새로 <span style="mso-bidi-font-size:10.0pt;mso-ascii-font-family:&quot;Courier New&quot;;
mso-hansi-font-family:&quot;Courier New&quot;;mso-bidi-font-family:&quot;Courier New&quot;;
color:red;mso-font-kerning:0pt;mso-no-proof:yes">넣을 <span style="mso-bidi-font-size:
10.0pt;mso-ascii-font-family:&quot;Courier New&quot;;mso-hansi-font-family:&quot;Courier New&quot;;
mso-bidi-font-family:&quot;Courier New&quot;;color:red;mso-font-kerning:0pt;mso-no-proof:
yes">메뉴]'',' + Convert(VARCHAR, permission) + ',getdate() )'<o:p></o:p>

FROM [KCMS2].[dbo].[AUTH_GroupPermission]<o:p></o:p>

WHERE FunctionID =
'DIMNG'<o:p></o:p>
</o:p>

테이블 내용을 Insert 문으로 변환 쿼리