Go4Expert - View Single Post - how to know explicitly the data type of a field in a database

urstop

You can execute the stored procedure sp_help with the tablename to get a resultset with the column names, data type and other extra info. You can use this resultset to extract the necessary colulmn name and data type information.

urstop Contributor
8Dec2009,14:54
	You can execute the stored procedure sp_help with the tablename to get a resultset with the column names, data type and other extra info. You can use this resultset to extract the necessary colulmn name and data type information.