| insert ' @tablename
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 ' ''''''
|
| 共16页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] 10 [11] [12] [13] [14] [15] [16] 下一页 |
评论加载中…
