全部复制select * into NewTable from OldTable
复制结构select * into NewTable from OldTable where 1=2
复制数据insert into NewTable (y1,y2,y3) select y1,y2,y3 from OldTable
远程数据库全部复制
select * into 新表 from opendatasource('SQLOLEDB','Data Source=数据库IP;User ID=用户名; Password=密码').远程数据库名称.dbo.远程数据库表