FORMAT FUNCTION
Some times it so happens that we have many leading zeros after a decimal number .
For example I am getting a result of a query say value of closing stock as 66000.000000 .
However I need to keep only 2 zeros after the decimal point and want the result as 66000.00 .
Here is a common trick of using the Format function.
Sometimes we need to disable constraints to work with...Here is how to do it
Identity column of a table is a column whose value increases automatically. A user generally cannot insert a value into an identity column. A table can have only one column that is defined with the identity attribute.
Syntax :
IDENTITY [ ( seed , increment ) ]
Default value of identity is IDENTITY (1,1).
Seed : The seed represents the starting value of an ID and the default value of seed is 1.
Increment : It will represent the incremental value of the ID and the default value of increment is 1.