How to insert data into a table in SQL Server?

 To insert data into a table in SQL Server, you can use the INSERT INTO statement. Here's an example of how to use the INSERT INTO statement to insert a new row of data into a table:

sql
INSERT INTO mytable (column1, column2, column3)
VALUES ('value1', 'value2', 'value3');

In this example, mytable is the name of the table that you want to insert data into. column1, column2, and column3 are the names of the columns that you want to insert data into. You can list as many columns as you need to insert data into, separated by commas.

The VALUES keyword is followed by a list of values that correspond to the columns you want to insert data into. In this example, we are inserting the values 'value1', 'value2', and 'value3' into the column1, column2, and column3 columns, respectively.

Note that the order of the values in the VALUES list must match the order of the columns in the INSERT INTO statement. If you want to insert NULL into a column, you can use the NULL keyword instead of a value.

You can also insert data into a table using a subquery or by inserting data from another table using the SELECT INTO statement. The syntax for these statements is slightly different, but the basic principles are the same.