Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - "INSERT INTO" - Inserting a New Row into a Table

By: FYIcenter.com

(Continued from previous topic...)

How To Insert a New Row into a Table with "INSERT INTO" Statements?

To insert a new row into a table, you can use the INSERT INTO statement with values specified for all columns as in the following syntax:

INSERT INTO table_name VALUES (list_of_values_of_all columns)

Note that the list of values of all columns must be specified in the same order as how columns are defined in the CREATE TABLE statement. The following tutorial example inserts a row into "fyi_links":

INSERT INTO fyi_links VALUES (101, 
  'dev.fyicenter.com', 
  NULL,
  0,
  '2006-04-30')
GO
(1 row(s) affected)

SELECT * FROM fyi_links
GO
id   url                notes  counts  created
101  dev.fyicenter.com  NULL   0       2006-04-30

The values are stored in the new record nicely.

(Continued on next topic...)

  1. What Are DML (Data Manipulation Language) Statements?
  2. How To Create a Testing Table with Test Data?
  3. How To Insert a New Row into a Table with "INSERT INTO" Statements?
  4. How To Use Column Default Values in INSERT Statements?
  5. How to provide column names in INSERT Statements?
  6. What Happens If You Insert a Duplicate Key for the Primary Key Column?
  7. How To Insert Multiple Rows with One INSERT Statement?
  8. How To Update Values in a Table with UPDATE Statements?
  9. How To Update Multiple Rows with One UPDATE Statement?
  10. How to use old values to define new values in UPDATE statements?
  11. Is the Order of Columns in the SET Clause Important?
  12. How To Use Values from Other Tables in UPDATE Statements?
  13. What Happens If the UPDATE Subquery Returns No Rows?
  14. What Happens If the UPDATE Subquery Returns Multiple Rows?
  15. How To Delete an Existing Row with DELETE Statements?
  16. How To Delete Multiple Rows with One DELETE Statement?
  17. How To Delete All Rows with DELETE Statements?
  18. How To Delete All Rows with TRUNCATE TABLE Statement?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...