What are defaults? Is there a column to which a default
can't be bound?
Answers were Sorted based on User's Feedback
Answer / swapna
A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ram
We can set Getdate() function by default to time stamp columns
| Is This Answer Correct ? | 4 Yes | 0 No |
What does nvl stand for?
What is difference in performance between insert top (n) into table and using top with insert?
Can we hide the definition of a stored procedure from a use?
What are the new data types are introduced in sql 2000?
How would you use user_constraints table in DB?
How to count the number of duplicate items in a table?
How to swap the data of two columns in a table. both the columns containing varchar values.
Explain indexed view?
What is table constraint?
What is difference between line feed ( ) and carriage return ( )?
How to edit table in sql server 2017?
What are the difference between clustered and a non-clustered index?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)