SQL SERVER数据导成INSERT

来源：互联网发布：apache2.4 加载php 编辑：程序博客网时间：2024/05/17 23:04

create     proc   spGenINSERT SQL
@TableName   as   varchar(100)
as
--declare   @TableName   varchar(100)
--set   @TableName   =   'orders'
--set   @TableName   =   'eeducation'
DECLARE   xCursor   CURSOR   FOR
SELECT   name,xusertype
FROM   syscolumns
WHERE   (id   =   OBJECT_ID(@TableName))
declare   @F1   varchar(100)
declare   @F2   integer
declare   @SQL   varchar(8000)
set   @SQL   ='SELECT   ''INSERT   INTO   '   +   @TableName   +   '   VALUES('''
OPEN   xCursor
FETCH   xCursor   into   @F1,@F2
WHILE   @@FETCH_STATUS   =   0
BEGIN
          set   @SQL   =@SQL   +
                              +   case   when   @F2   IN   (35,58,99,167,175,231,239,61)   then   '   +   case   when   '   +   @F1   +   '   IS   NULL   then   ''''   else   ''''''''   end   +   '     else   '+'   end
                              +   'replace(ISNULL(cast('   +   @F1   +   '   as   varchar(8000)),''NULL''),'''''''','''''''''''')'
                              +   case   when   @F2   IN   (35,58,99,167,175,231,239,61)   then   '   +   case   when   '   +   @F1   +   '   IS   NULL   then   ''''   else   ''''''''   end   +   '     else   '+'   end
                              +   char(13)   +   ''','''
          FETCH   NEXT   FROM   xCursor   into   @F1,@F2
END
CLOSE   xCursor
DEALLOCATE   xCursor
set   @SQL   =   left(@SQL,len(@SQL)   -   5)   +   '   +   '')''   FROM   '   +   @TableName
exec   (@SQL)

go

EXEC spGenINSERT SQL *TBLNAME*<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>