SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags


    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 SQL_VARIANT_PROPERTY ( 'column_name' , 'basetype'...
    Posted to Madhivanan (Weblog) by Madhivanan on Sat, Nov 1 2008
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems