Browse by Tags

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