when a.xtype =62  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(23),''''+a.name +'''',2)''''+'''' end''''

       when a.xtype =56  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(11),''''+a.name +'''')''''+'''' end''''

       when a.xtype =60  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(22),''''+a.name +'''')''''+'''' end''''

       when a.xtype =239 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''

       when a.xtype =108 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(''''+convert(varchar(4),a.xprec+2)+''''),''''+a.name +'''')''''+'''' end''''

       when a.xtype =231 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''

       when a.xtype =59  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(23),''''+a.name +'''',2)''''+'''' end''''

       when a.xtype =58  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''convert(varchar(23),''''+a.name +'''',121)''''+ ''''+''''''''''''''''''''''''''''''''''''+'''' end''''

       when a.xtype =52  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(12),''''+a.name +'''')''''+'''' end''''

       when a.xtype =122 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(22),''''+a.name +'''')''''+'''' end''''

       when a.xtype =48  then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(6),''''+a.name +'''')''''+'''' end''''

--     when a.xtype =165 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(''''+convert(varchar(4),a.length*2+2)+''''),''''+a.name +'''')''''+'''' end''''

       when a.xtype =167 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''

       else ''''''''''''NULL''''''''''''

       end as col,a.colid,a.name

       from syscolumns a where a.id = object_id(@tablename) and a.xtype <>189 and a.xtype <>34 and a.xtype <>35 and  a.xtype <>36

       )t order by colid

       select @sqlstr=@sqlstr+left(@sqlstr2,len(@sqlstr2)-1)+'''') ''''+left(@sqlstr1,len(@sqlstr1)-3)+'''')'''''''' from ''''+@tablename

--  print @sqlstr

       exec( @sqlstr)

       set nocount off

end

GO

说明：本贴纯属收藏，目的在于大家交流，在此对作者表示感谢！

上一页  [1] [2] [3] [4] [5] [6] [7] [8]  下一页