'''' end'''' 300 301 when xtype in (239) 302 303 then ''''case when ''''+ name +'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''N'''''''''''''''''''''''' + '''' + ''''cast(replace(''''+ name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''') as Char('''' + cast(length as varchar) + ''''))+''''''''''''''''''''''''''''''''''''+'''' end'''' 304 305 else ''''''''''''NULL'''''''''''' 306 307 end as Cols,name 308 309 from syscolumns 310 311 where id = object_id(@tablename) 312 313 ) T 314 315 set @sql =''''select ''''''''INSERT INTO [''''+ @tablename + '''']'''' + left( << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> |