Answer Posted / s. elaiyaraja
Default is the column value used in the sql.
if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.
For example varchar columns are defined as null value for
default value.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to sort the query output with order by clauses in ms sql server?
What is index fragmentation in ms sql server?
What is the recovery model? List the types of recovery model available in sql server?
What part does database design plays a role in performance of an sql server-based application?
Is a primary key unique?
Define right outer join in sql server joins?
Do you know what are various aggregate functions that are available?
What is the report model project?
What does nvl stand for?
What is the stored procedure?
What are locks in sql?
How do I view a trc file?
Why should one not prefix user stored procedures with ‘sp_’?
what are the different types of replication you can set up in sql server? : Sql server database administration
Describe the functionalities that views support.