SQL INSERT Statement

The SQL INSERT statement adds new records into tables or loads data into tables. The syntax of this insert statement is INSERT INTO [DestinationTable] ([Column1], [Column2],…, [ColumnN]) VALUES ([Column1_Value], [Column2_Value],…, [ColumnN_Value]) We can write this SQL Server Insert Statement as, INSERT INTO [DestinationTable] VALUES ([Column1_Value], [Column2_Value],…, [ColumnN_Value]) This table holds two records, and we will perform … Read more