SQL Server 2005 – Difference between datetime and smalldatetime datatype with example

Here we will discuss about some difference between datetime and small datetime datatype in sql server 2005. We are very much familiar with writing procedure or T-SQL command while doing that we have so many time used date to identify data in table. Also while storing date value, used datetime datatype. Let us find out the difference between datetime ...