Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

mssql : INFORMATION_SHEMA DATA_TYPE problem

2 Posts 2 Posters 0 Views 1 Watching

F Offline
F Offline
frakk

wrote on last edited by

#1

Hi! I have a problem, query is : "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SHEMA.COLUMNS", then result DATA_TYPE field is empty, why ? OS:WIN CE DEV:eVC++ ADOCE MSSQL
J 1 Reply Last reply

0
F frakk

Hi! I have a problem, query is : "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SHEMA.COLUMNS", then result DATA_TYPE field is empty, why ? OS:WIN CE DEV:eVC++ ADOCE MSSQL
J Offline
J Offline
Joao Paulo Figueira

wrote on last edited by

#2

Do you get a proper value from COLUMN_NAME? Note that DATA_TYPE is a numeric value. Regards, João Paulo Figueira Embedded MVP
1 Reply Last reply

0

Log in to reply