SQL Server database Type insert statement usage insertintoemproyee (e_name, e

Just after SQL Server inserts multiple data records into the insert statement, insert a single data record: insertintoemproyee (e_name, e_sex) values (Tang Jia sanshao, 0); insertintoemproyee (e_name, e_sex) select skeleton genie, more than 0 Data inserts: insertintoemproyee (e_name, e_sex) select silkworm Soil

Just after SQL server inserts multiple data records into the insert statement, the following data is inserted: insert into emproyee (e_name, e_sex) values ('tang Jia sanshao ', 0 ); insert into emproyee (e_name, e_sex) select 'skeleton genie ', more than 0 Data inserts: insert into emproyee (e_name, e_sex) select 'silkworm Soil

Summary when SQL server inserts multiple data records into the insert statement

Insert a single data entry:

Insert into emproyee (e_name, e_sex) values ('tang Jia San Shao ', 0 );
Insert into emproyee (e_name, e_sex) select 'skeleton genie ', 0

Insert multiple data entries:

Insert into emproyee (e_name, e_sex) select 'silkworm Potato ', 0
Union all select 'eat tomato ', 0
Union all select 'inverse heaven ', 0