Interested to Buy Any Domain ? << Click Here >> for more details...
What are defaults? Is there a column to which a default
can't be bound?
- 2 Answers
- 8959 Views
- TCS, I also Faced
- E-Mail Answers
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 |
SQL Server Architecture ?
What do you understand by a view? What does the with check option clause for a view do?
How can a user-defined datatype be created?
What are approximate numeric data types in ms sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is cross join in sql server joins?
What is BLOCK statements in SQL?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Do you have any idea about the tcl commands?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is difference between unique and primary key?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
-
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)
