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
What is ems sql management studio? : sql server management studio
What is table valued function and scalar valued functions?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Describe in brief sql server monitoring ways.
How can delete duplicate records in cte in sql server?
Is BCNF better than 2NF & 3NF? Why?
What are commonly used odbc functions in php?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Why truncate is ddl?
What is sqlcmd?
What is format parameter in ssrs?
How to check parameter value in stored procedure sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
can any body tell me how to know the password of current user in sql server