转移数据库表数据

use UzaiTravel
insert into [UzaiTravel].[dbo].[UzaiIndexNavRecommend]([Title]
,[City]
,[Parent]
,[Url]
,[TypeName]
,[PageType]
,[Sort]
,[NavLevel]
,[Style]
,[StyleName]
,[LocationY]
,[NavGroupID]
,[IsThirdNavStress])
select [Title]
,[City]
,[Parent]
,[Url]
,[TypeName]
,[PageType]
,[Sort]
,[NavLevel]
,[Style]
,[StyleName]
,[LocationY]
,[NavGroupID]
,[IsThirdNavStress] from [UzaiTravel_BAK].[dbo].[UzaiIndexNavRecommend]

转移数据库表数据

原文：http://www.cnblogs.com/donchen/p/5301506.html