/span>+col+'+'',''+' ,@sqlstr2=@sqlstr2+name +',' from (select case
368
369
-- 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'
370
371
when a.xtype =104 then 'case when '+a.name+' is null then ''null'' else '+'convert(varchar(1),'+a.name +')'+' end'
372
373
when a.xtype =175 then 'case when '+a.name+' is null then ''null'' else '+'''''''''