''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(6),''''+a.name +'''')''''+'''' end'''' 400 401-- 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'''' 402 403when a.xtype =167then''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')''''+''''+''''''''''''''''''''''''''''''''''''+'''' end'''' 404 405else''''''''''''NULL'''''''''''' 406 407endas col,a.colid,a.name 408 409from syscolumns a where a.id =object_id(@tablename) and a.xtype <>189and a.xtype <>34and a.xtype <>35and a.xtype <>36 410 411 )t orderby colid 412
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
