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 are cursors?
Does union all remove duplicates?
What is dynamic cursor in SQL SERVER?
Why would you call update statistics?
What can be used instead of trigger?
What do you mean by normalisation?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are partitioned views and distributed partitioned views?
What is a cube? : sql server analysis services, ssas
Tell me what is use of except clause? How it differs from not in clause?
Give the query of getting last two records from the table in SQL SERVER?
0 Answers Petranics Solutions,
What is trigger ?
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)