Batch Selected Rows Insert MSSQL Tutorial

How To Batch Selected Insert Rows In MSSQL Database Server Tutorial Example

Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to batch selected rows insert into a table usinq sql command or statement in MSSQL Database Server Tutorial Example

   INSERT INTO executives(lastname,department,salary)
   VALUES ('Wasif Osman','IT',50000),
   ('Pavel','Mediation',45000),
   ('Iqbal Hosan','RAFM System',35000)
 

/*
   CREATE TABLE executives
   (
   lastname varchar(50) NOT NULL,
   department varchar(50) NULL,
   join_date date NULL,
   salary numeric(18, 0) NOT NULL
   ) ON [PRIMARY]
*/
   create the table using above code;
   if it is not created yet before batch inserting.
   /* */ is multiline code comments in MSSQL
   -- is comment in MSSQL
   -- in fact it is comment in Oracle and MySQL as well

How To Batch Selected Insert Rows In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools