将一个数据库里的表及数据复制到另一个数据库的表里及更新一个表的字段到另一个表里

过程：表点击右按键，编写脚本为，create到，新查询编辑器窗口

--创建表begin

USE [tagen_020test]    ----更换为新的数据库名字即可
GO


/****** Object:  Table [dbo].[Park_JparkCodes]    Script Date: 2017/11/29 11:44:18 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Park_JparkCodes](
[jparkId] [int] IDENTITY(1,1) NOT NULL,
[propertyId] [int] NULL,
[propertyNo] [nvarchar](50) NULL,
[jparkName] [nvarchar](50) NULL,
[remark] [nvarchar](50) NULL,
[parkCode] [nvarchar](50) NULL,
[parkName] [nvarchar](50) NULL,
[jparkCode] [nvarchar](50) NULL,
[addTime] [datetime] NULL,
[updateTime] [datetime] NULL,
[status] [int] NULL,
 CONSTRAINT [PK_Park_JparkCodes] PRIMARY KEY CLUSTERED 
(
[jparkId]