备份一个表到新表或备份一个表到架构相同的表

--建表并拷贝数据

  SELECT * INTO 表1 FROM 表2

 

--将表1数据插入到相同结构的数据表2中

INSERT INTO 表1  SELECT * FROM 表2

--将表1的部分字段以及数据 拷贝到表2中   

 INSERT    [dbo].[AM_F_BusinessOperationMonthAMT]
            ( ProjectID ,
              [BrandName]
            )
            SELECT  ProjectID ,
                    rownum = ROW_NUMBER() OVER ( ORDER BY ProjectID DESC )
            FROM   [dbo].[AM_F_BusinessOperation]

  SELECT * INTO 表1 FROM 表2

--SELECT * INTO [dbo].[AM_F_BusinessOperationMonthAMT] FROM [dbo].[AM_F_BusinessOperation]

INSERT INTO [dbo].[AM_F_BusinessOperationMonthAMT] SELECT * FROM [dbo].[AM_F_BusinessOperation] 

//在已知#table1203临时表结构时 可以将select出来union以后的数据插入到临时表中

INSERT INTO #table1203  SELECT   CAST( PlazaName  AS NVARCHAR) AS value  FROM dbo.AM_Assets UNION SELECT CAST( PlazaKey AS NVARCHAR) AS value FROM dbo.AM_Assets