|
INTERVIEW QUESTIONS
DATABASE
MS SQL SERVER
DETAILS
Question: How To Use Column Default Values in INSERT Statements in MS SQL Server?
Answer: If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:
INSERT INTO ggl_links VALUES (102, 'www.globalguideline.com', NULL, 0, DEFAULT) GO (1 row(s) affected)
SELECT * FROM fyi_links GO id url notes counts created 101 www.globalguideline.com NULL 0 2006-04-30 102 www.globalguideline.com NULL 0 2007-05-19
The default value, getdate(), is used for "created" column, which gives the current date.
|
|
|
Category |
MS SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7545 users |
Added on |
9/23/2014 |
Views |
66125 |
Rate it! |
|
|
Question:
How To Use Column Default Values in INSERT Statements in MS SQL Server?
Answer:
If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:
INSERT INTO ggl_links VALUES (102, 'www.globalguideline.com', NULL, 0, DEFAULT) GO (1 row(s) affected)
SELECT * FROM fyi_links GO id url notes counts created 101 www.globalguideline.com NULL 0 2006-04-30 102 www.globalguideline.com NULL 0 2007-05-19
The default value, getdate(), is used for "created" column, which gives the current date. 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 Insert a New Row into a Table with "INSERT INTO" Statements in MS SQL Server?
|
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
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All MS SQL Server Interview Questions & Answers - Exam Mode /
Learning Mode
|