How to Select,insert,update Query using SQL Server with example.

 Select Query  :-

 SQL SELECT Syntax

SELECT column_name,column_name
FROM table_name;

andSELECT * FROM table_name;

 Example:

 Insert Query:- 
 SQL INSERT INTO SyntaxIt is possible to write the INSERT INTO statement in two forms.

The first form does not specify the column names where the data will be inserted, only their values:
INSERT INTO table_name
VALUES (value1,value2,value3,...);

The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

 Example:

Also show in Table-dbo.person  Add record values (12, krima)

Update query:-

The SQL UPDATE Statement

The UPDATE statement is used to update existing records in a table.
SQL UPDATE Syntax
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

  Example:

Also show in Table-dbo.person  Update record values (12, krima) replace by (12,myname)

stored procedure