Browse by Tags

Working with DateTime data types in SQL Server, guidelines and explanations!

Published 26 August 8 2:41 AM | SSQA.net

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...

Filed under: datetime, sql server, usage, global, datatype, guidelines

FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"

Published 26 October 7 2:40 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQLL Server 2005 Enterpris X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, database, kba, datatype, column, dbcc checktable, float, dbcc checkdb

Better way to handle and validate IP Address data column

Published 26 July 7 3:34 AM | SSQA.net

One of the developer asked a question to handle and parse the IP Address data on a table, as you are aware IP Address data would have 4 sections and to parse each 4-part value is requried for reduce any duplication. You could take hlep of SUBSTRING and...

Filed under: datatype, tsql, ip address, parsename

How do I find the data types such as xml or text or image of a specified table?

Published 18 July 7 9:34 AM | SSQA.net

USE <database_name>; GO SELECT name AS column_name ,column_id ,TYPE_NAME(user_type_id) AS type_name ,max_length ,CASE WHEN max_length = -1 AND TYPE_NAME(user_type_id) <> 'xml' THEN 1 ELSE 0 END AS [(max)] FROM sys.columns WHERE object_id...

Filed under: xml, datatype, tsql, tables, image, lob

New and old blend of data-types in SQL Server 2008

Published 9 July 7 9:8 AM | SSQA.net

By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware...

Filed under: sql server, database, 2008, new, data capture, datatype