first question:exec sp_dboption DATABASENAME, 'select into/bulkcopy', true select * into NEWTABLE from OLDTABLE where 1=0 exec sp_dboption words, 'select into/bulkcopy', falsesecond question:exec sp_dboption DATABASENAME, 'select into/bulkcopy', true select * into NEWTABLE from OLDTABLE exec sp_dboption words, 'select into/bulkcopy', falseuse sp_dboption is because usually database is not in the bulkcopy mode, so select into statement can't run.
select * into NEWTABLE from OLDTABLE where 1=0
exec sp_dboption words, 'select into/bulkcopy', falsesecond question:exec sp_dboption DATABASENAME, 'select into/bulkcopy', true
select * into NEWTABLE from OLDTABLE
exec sp_dboption words, 'select into/bulkcopy', falseuse sp_dboption is because usually database is not in the bulkcopy mode, so select into statement can't run.
语句就可以生成了,你把他保存下来,然后把SQL语句中的表名改成新表的名字,执行SQL语句就
可以产生新表了。