Collections:
"INSERT INTO" - Inserting a New Row into a Table in SQL Server
How To Insert a New Row into a Table with "INSERT INTO" Statements in SQL Server?
✍: FYIcenter.com
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.
2016-11-03, 744👍, 0💬
Popular Posts:
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...