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 is statistics
How do I start and stop sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What all db objects can be found in MSDB database of a SQL Server instance?
What is sql stored procedure?
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?
What are “unrepeatable reads”?
Explain how does the report manager work in ssrs?
What is the difference between inner join and equi join?
How to write a query with a right outer join in ms sql server?
what is diffence between replicaion and logshipping?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
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)