Insert Statement with an example

Brief about Insert Statement with an example.

INSERT: The Insert statement is used to insert values as rows in a table.

Syntax:
INSERT INTO Table_name values (value1, value2,…);
INSERT INTO Table_name (column1, colum2…) values (value1, value2,…);

Example
A table customer has fields customer id, customer name, customer salary.
INSERT INTO customer (1,John,20000);
Select….into statement with an example
Select into is used to create back up copies of tables. It selects data from one table and inserts into another......
Bulk copy with an example
Bulk copy utility of SQL allows data to be copied from one data file to another........
How bcp command prompt utility is used to import and export data
The bcp utility is accessed from the command prompt......
Post your comment