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 |
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the difference between mysql and sql server?
how to control the amount of free space in your index pages? : Sql server database administration
How to insert data with null values?
In join, which clause in not used?
How to configure and test odbc dsn settings?
How to delete an existing row with delete statements in ms sql server?
Explain indexed views and partitioned view with their syntax.
How to download and install sql server 2005 books online?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What are the 10 characteristics of data quality?
How to use “drop” keyword in sql server and give an example?
Oracle (3259)
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)