SQL Server 2008 has introduce new data type for date and time data types: DATE, TIME, DATETIME2, and DATETIMEOFFSET. These new date and time data types offer higher precision, large year range, and time zone awareness and preservation and therefore more fl exibility when defi ning your data domain. The following table gives a summary [...]
Archive for the ‘SQL Server 2008’ Category
SQL Server 2008 New Data Types
Posted in SQL Server 2008 on February 23, 2010 | 1 Comment »
SQL Server 2008 New Features
Posted in SQL Server 2008 on February 19, 2010 | 1 Comment »
Intellisense Built-in intellisense in SQL Server Management Studio is very much of useful for developer who feels better on writing code. Avoid syntax error. Fast writing codes. Good for beginners they can easily learn the database schema as they go. Inline variable assignment In this feature you can assign the value while declaring the object [...]
