Browse by Tags

All Tags » datatype   (RSS)
Better way to handle and validate IP Address data column
26 July 07 01:34 AM | SQL Master | 1 Comments   
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 Read More...
How do I find the data types such as xml or text or image of a specified table?
18 July 07 07:34 AM | SQL Master | 1 Comments   
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=OBJECT_ID('<schema_name.table_name>') Read More...
Filed under: , , , , ,