User Id :    Password :      New Member   Forgot Password  
Topic: What is defaults in Sql Server and types of Defaults
Sachin Jain
30 Oct 2010 at 01:38 AM
What is defaults in Sql Server and types of Defaults.

Re: What is defaults in Sql Server and types of Defaults
Gaurav
31 Oct 2010 at 11:56 PM

Defaults are used when a field of columns is almost common for all the rows for example in employee table all living in delhi that value of this field is common for all the row in the table if we set this field as default the value that is not fill by us automatically fills the value in the field its also work as intelligence means when user inputting d it will automatically fill the delhi . There are two types of defaults object and definitions.
Object default:-These defaults are applicable on a particular column. These are usually denied at the time of table designing. When u set the object default field in column state this column in automatically field when u left this filed blank.
Definition default:-When we bind the datatype with default let we named this as dotnet .Then every time we create column and named its datatype as dotnet it will behave the same that we set for dotnet datatype.

Total Replies: 1
 
Featured Text Ad

Featured Ad