I have the following query which will get the column name of the table I am trying to work on ..
ÃÂ· SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'MyDataTable'
This query will give me the column name of "MyDataTable". But I need to add some calculated field - i.e get the number of rows which are not null from "myDataTable" for a particular column.
I tried :
myField = (Select Count(*) from myDataTable);
FROM INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'MyDataTable'
The above one gives me the total number of rows in the "myDataTable"
Anybody that have some kind of idea for a work around please help.
View Complete Post