Several ways in which SQL Server inserts data (base)

1 Insert  into Table(Field1,field2,...)Values(Value1,value2,...)--inserting A single piece of data2 3 Insert  into Table(Field1,field2,...)SelectValue1,value2,...Union SelectValue1,value2,...--Insert multiple data, do not allow default4 5 Insert  intoTable2 (Field1,field2,...)SelectField1,field2,... fromTable1--table 2 must be present6 7 SelectField1,field2,... intoTable2 fromTable1--CREATE table 2, copy table 1 data to table 2

Several ways in which SQL Server inserts data (base)