T-SQL Tutorial T-SQL Advanced Database Management T-SQL References

T-SQL - VALUES Keyword



The T-SQL (Transact-SQL) VALUES keyword is used to specify the values of an T-SQL INSERT INTO statement. There are two ways of using VALUES keyword which are mentioned below:

Syntax

The below syntax specifies column names and respective values to be inserted.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

The below syntax specifies values only. Therefore, it is essential to specify values in the same order as the columns in the table.

INSERT INTO table_name 
VALUES (value1, value2, value3, ...);

Example:

Consider a database containing a table called Employee with the following records:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

  • Using below query, two new records are added in the Employee table:

    INSERT INTO Employee (EmpID, Name, City, Age, Salary)
    VALUES (7, 'Suresh', 'Mumbai', 29, 2900);
    INSERT INTO Employee 
    VALUES (8, 'Zayne', 'Oslo', 31, 3400);
    
    -- see the result
    SELECT * from Employee
    

    Now the Employee table will contain following records:

    EmpIDNameCityAgeSalary
    1JohnLondon253000
    2MarryNew York242750
    3JoParis272800
    4KimAmsterdam303100
    5RameshNew Delhi283000
    6HuangBeijing282800
    7SureshMumbai292900
    8ZayneOslo313400
  • Insert Data Only in Specified Columns: To insert data in specified columns, it is necessary to specify column names. See the query given below:

    INSERT INTO Employee (EmpID, Name, Age)
    VALUES (7, 'Suresh', 29);
    
    -- see the result
    SELECT * from Employee
    

    Now the Employee table will contain following records:

    EmpIDNameCityAgeSalary
    1JohnLondon253000
    2MarryNew York242750
    3JoParis272800
    4KimAmsterdam303100
    5RameshNew Delhi283000
    6HuangBeijing282800
    7Suresh 29

❮ T-SQL Keywords