|
INTERVIEW QUESTIONS
DATABASE
MS SQL SERVER
DETAILS
Question: How To Insert a New Row into a Table with "INSERT INTO" Statements in MS SQL Server?
Answer: 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 "ggl_links":
INSERT INTO ggl_links VALUES (101, 'www.globalguideline.com', NULL, 0, '2006-04-30') GO (1 row(s) affected)
SELECT * FROM ggl_links GO id url notes counts created 101 www.globalguideline.com NULL 0 2006-04-30
The values are stored in the new record nicely.
|
|
|
Category |
MS SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6571 users |
Added on |
9/23/2014 |
Views |
66562 |
Rate it! |
|
|
Question:
How To Insert a New Row into a Table with "INSERT INTO" Statements in MS SQL Server?
Answer:
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 "ggl_links":
INSERT INTO ggl_links VALUES (101, 'www.globalguideline.com', NULL, 0, '2006-04-30') GO (1 row(s) affected)
SELECT * FROM ggl_links GO id url notes counts created 101 www.globalguideline.com NULL 0 2006-04-30
The values are stored in the new record nicely. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How To Create a Testing Table with Test Data in MS SQL Server?
|
View Answer
|
|
What Are DML (Data Manipulation Language) Statements in MS SQL Server?
|
View Answer
|
|
How To Drop an Existing Table with "DROP TABLE" Statements in MS SQL Server?
|
View Answer
|
|
How to rename an existing table with the "sp_rename" stored procedure in MS SQL Server?
|
View Answer
|
|
How to rename an existing column with SQL Server Management Studio?
|
View Answer
|
|
How to rename an existing column with the "sp_rename" stored procedure in MS SQL Server?
|
View Answer
|
|
How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in MS SQL Server?
|
View Answer
|
|
How to create new tables with "SELECT ... INTO" statements in MS SQL Server?
|
View Answer
|
|
How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?
|
View Answer
|
|
How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?
|
View Answer
|
|
How To Get a List of Table Columns using the "sp_columns" Stored Procedure in MS SQL Server?
|
View Answer
|
|
How To Get a List of Columns using the "sys.columns" View in MS SQL Server?
|
View Answer
|
|
How To Get a List of All Tables with "sys.tables" View in MS SQL Server?
|
View Answer
|
|
How to create new tables with "CREATE TABLE" statements in MS SQL Server?
|
View Answer
|
|
What are DDL (Data Definition Language) statements for tables in MS SQL Server?
|
View Answer
|
|
What is a database table?
|
View Answer
|
|
What are system databases in MS SQL Server?
|
View Answer
|
|
How to set database to be SINGLE_USER in MS SQL Server?
|
View Answer
|
|
How to set database to be READ_ONLY in MS SQL Server?
|
View Answer
|
|
How to move database physical files in MS SQL Server?
|
View Answer
|