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

Q

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

✍: FYIcenter.com

A

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.

 

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-03, 548👍, 0💬