When you are working with different types of databases (MSSQL, MySQL, Oracle, …), you tend to forget the syntax for some logic you want to implement.

Today I’m going to list different statements on how to insert multiple rows with a single statement.
Let’s say that we have a table, called “User”. Our table contains 3 fields: “UserId”, “UserName”, “Email”. Now we can start adding some rows.

continue reading…