select * into [FZ_0513].[dbo].[stock_PriceModify_detail] from [FZ_0320].[dbo].[stock_PriceModify_detail]
数据库名称.dbo.表名
情况一:data2表中无table2表
select * into data2.dbo.table2in data2 from data1.dbo.table1
情况二:结构不一样或者你要指定字段
insert into data2.table2(字段1,字段2,字段) select 字段j,字段k,字段m fromdata1.table1
情况三:结构一样
insert into data2.table2select * from data1.table1