- DATE - occupies 3 bytes . Has accuracy of 1 day . Data stored in 'YYYY-MM-DD' format
- TIME - occupies 3 to 5 bytes . Has accuracy of 100 nanoseconds. Data stored in 'hh:mm:ss.nnnnnnn' format.
- DATETIME2 - occupies 6 to 8 bytes . Has accuracy of 100 nanoseconds. Data stored in 'YYYY-MM-DD hh:mm:ss.nnnnnnn' format.
- DATETIMEOFFSET - occupies 8 to 10 bytes . Has accuracy of 100 nanoseconds. Data stored in 'YYYY-MM-DD hh:mm:ss.nnnnnnn [+|-]hh:mm' format. The DATETIMEOFFSET data type is similar to DATETIME2 but has time zone component extra.
State some new data types in SQL Server 2008 ?
New Data types in SQL Server 2008 are :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
New Data types in SQL Server 2008 are : DATE - occupies 3 bytes . Has accuracy of 1 day . Data stored in 'YYYY-MM-DD' format TIME...
-
Question : State whether below class relationship is correct or not . If not why ? class A: B {} class B: C {} class C: A {} Answer...
-
How to pass null values to stored procedure from code behind ? Pass the parameter’s value as DBNull.Value from code-behind.
-
Different validation controls in ASP.NET are as follows : RequiredFieldValidator CompareValidator RangeValidator RegularExpressionValida...
-
Different types of primary behaviours are as follows : Service Behaviour Endpoint Behaviour Operation Behaviour Callback Behaviour
-
Cache object belongs to System.Web.Caching namespace.
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
Custom HTTPmodule is created for: URL rewriting Compression Specialized authentication and authorization Specialized logging
-
Types of DML statements : Select Insert Update Delete
-
Question : You and a group of programmers have written a new web application using Visual Studio.NET for a new client. The application trac...
Posts
No comments:
Post a Comment