--1.創建測試表

    create TABLE Table1

    (

         a varchar(10),

         b varchar(10),

         c varchar(10),

         CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED

         (

             a ASC

         )

    ) ON [PRIMARY]

    create TABLE Table2

    (

         a varchar(10),

         c varchar(10),

         d int,

         CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED

         (

             a ASC

         )

    ) ON [PRIMARY]

    GO

    --2.創建測試數據

    Insert into Table1 values('趙','asds','90')

    Insert into Table1 values('錢','asds','100')

    Insert into Table1 values('孫','asds','80')

    Insert into Table1 values('李','asds',null)

    GO

    select * from Table2

    --3.INSERT INTO SELECT語句復制表數據

    Insert into Table2(a, c, d) select a,c,5 from Table1

    GO

    --4.顯示更新后的結果

    select * from Table2

    GO

    --5.刪除測試表

    drop TABLE Table1

    drop TABLE Table2

SELECT INTO FROM語句

    --1.創建測試表

     create TABLE Table1

    (

         a varchar(10),

         b varchar(10),

         c varchar(10),

         CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED

         (

             a ASC

         )

    ) ON [PRIMARY]

    GO

    --2.創建測試數據

     Insert into Table1 values('趙','asds','90')

    Insert into Table1 values('錢','asds','100')

    Inser