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 the difference between update lock and exclusive lock?
What is isnull() operator?
What are ddl triggers and types of ddl trigger?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the default port for SQL Server over a firewall?
Do you know the different ddl commands in sql?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to check table values in sql server?
What is trigger ?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
How make remote connection in database?
What is buffer cash and log cache in sql server?
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)