...

I often see that some junior develepers forget an important thing while designing a table. They choose wrong datatypes to store data ie VARCHAR to store DATETIME or DECIMAL values. This is mostly identified either when verifying the design or giving som...

...

...

Thank you all for your feed backs...

...

RAND function in SQL Server is used to generate a random value between 0 and 1. When you use RAND in the SELECT statement, it generates the same value for the entire resultset. One of my friends asked me if it is possible to have different random values...

Money is one of the datatypes in SQL Server and it can be used to store monetary values. It will not only accept integer and decimal values but formatted values too. For example you can express values that include comma and currency symbol Consider the ...

...

...