What are defaults? Is there a column to which a default
can't be bound?
Answers were Sorted based on User's Feedback
Answer / guest
Defaults are used to assign some defalut values to
columns . These values are used if user doen to specify a
column value.
Timestamp canot have default clause attached to it
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / leena
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 ? | 4 Yes | 0 No |
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How you can make a parameterized view?
Explain about the hierarchical model of the database?
What is the system function to get the current user's user id?
What are the constraints on severity level in raiseerror?
can you give me the syntax of named procedure??
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the main phases of database development?
Explain the role of indexing in databases?
How to use timestamp datatypes
How to create an external table.
Can you instantiate a COM object by using T-SQL?
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)