create proc proc_insert (@tablename varchar(256))
as
begin
set nocount on
declare @sqlstr varchar(4000)
declare @sqlstr1 varchar(4000)
declare @sqlstr2 varchar(4000)
select @sqlstr=’select ”insert
select @sqlstr1=”
select @sqlstr2=’ (‘
select @sqlstr1= ‘ values ( ”+’
select @sqlstr1=@sqlstr1+col+’+”,”+’ ,@sqlstr2=@sqlstr2+name +’,’ from (select case
— when a.xtype =173 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 =104 then ‘case when ‘+a.name+’ is null then ”NULL” else ‘+’convert(varchar(1),’+a.name +’)’+’ end’
when a.xtype =175 then ‘case when ‘+a.name+’ is null then ”NULL” else ‘+””””’+’+’replace(‘+a.name+’,””””,””””””)’ + ‘+””””’+’ end’
when a.xtype =61 then ‘case when ‘+a.name+’ is null then ”NULL” else ‘+””””’+’+’convert(varchar(23),’+a.name +’,121)’+ ‘+””””’+’ end’
when a.xtype =106 then ‘case when ‘+a.name+’ is null then ”NULL” else ‘+’convert(varchar(‘+convert(varchar(4),a.xprec+2)+’),’+a.name +’)’+’ end’
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 +
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1837546.html
