SQL server database Type insert statement usage insert into emproyee (e_name, e_sex) values (& #39; Tang Jia sanshao & #39;, 0); insert into emproyee,

SQL server database Type insert statement usage insert into emproyee (e_name, e_sex) values ('tang Jia San Shao ', 0); insert into emproyee,

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