Default values are prespecified values which are used when the user doesn`t provide the input to the column. It can be useful in various situations, for
example :
1. There is a Sales table in your database and on that table there is a column Saledate, which holds the date of the Sale. So in that case you no need to insert the date explicitly in the code, if the sale date`s default value is current date using getdate() function, it will take the current sale date.
2. Default Image Path: you have a user table in your database and you keep the image URL in a user table, then you can use a default Image path in the image path table, so whenever the user does not provide there image default image shows on the website.
3. Default Country: for example a business operates in mainly in a country, but they sometimes do business outside of their county, then they can use the default country name as their head office`s country name.
4. Default Status: website like Dotnetfunda.com uses new user status as
"Starter" even in that case they also might be using the default value:) etc etc...
Default value isn`t a must have or a big problem solver kind of feature, but it`s quite handy and saves some time.
We welcome everybody to contribute to this question answer series.
Contact for Free SQL Server Performance Consulting and Training for you or your Organization.
Neerajprasadsharma, if this helps please login to Mark As Answer. | Alert Moderator