| varchar(8000)
set @sql =' ('
set @sqlValues = 'values ('' '
select @sqlValues = @sqlValues cols ' '','' ' ,@sql = @sql '[' name '],'
from
(select case
when xtype in (48,52,56,59,60,62,104,106,108,122,127)
then 'case when ' name ' is null then ''NULL'' else ' 'cast(' name ' as varchar)' ' end'
when xtype in (58,61)
then 'case when ' name ' is null then ''NULL'' else ' ''''''''' ' 'cast(' name ' as varchar)' ' ''''''''' ' end'
when xtype in (167)
|
| 共16页: 上一页 [1] [2] [3] [4] [5] 6 [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] 下一页 |
评论加载中…
