转移数据库表数据

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]

posted on 2016-03-21 13:16  donchen-c  阅读(169)  评论(0编辑  收藏  举报