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
Explain different types of Normalization.
What causes index fragmentation?
What is save transaction and save point?
Can two tables share a primary key?
What do you mean by a Composite primary key?
What is @@error in sql?
Define Joins?
What is the command used to check locks in microsoft sql server?
Find first and last day of current month in sql server
Can a function call a stored procedure in sql server?
How to list all user names in a database?
Explain a checkpoint?
What is shared lock?
what is hash nonclustered index
What are the advantages of log shipping?