Browse by Tags

All Tags » SQL_VARIANT_PROPERTY » T-sql (RSS)

SQL_VARIANT_PROPERTY function

If you want to know the datatype or length of a column , you can query on the system table syscolumns or system view INFORMATION_SCHEMA.COLUMNS But you dont need to query on system objects if you use SQL_VARIANT_PROPERTY function Example SELECT TOP 1...
Posted by Madhivanan | with no comments