what is meant by deafult in sql server?

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


Please Help Members By Posting Answers For Below Questions

Does order by actually change the order of the data in the tables or does it just change the output?

915


What are the purpose of Normalisation?

801


How to round a numeric value to a specific precision?

769


Can binary strings be converted into numeric or float data types?

746


How do you delete a trigger?

744






Is it possible to replicate data from sql server to oracle? : sql server replication

746


If the job running very slow what is the action you do

1601


What is sqlcmd?

714


How can you append an identity column to a temporary table?

625


What is table level trigger?

760


What is an index in sql?

729


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1558


what are the reporting service components in SSRS?

139


What is log in sql server?

761


What are truncate options available in sql server? : sql server database administration

746