Check whether value is there in a column table

[seeism]

Hi, I have a function which can add custom column types to my table.In that there is a provision to delete the columns also.So when deleting my column i need to check whether this column contains any data or not.How to do this> Seeism

[seeism]

HI, SELECT @vCount=('select COUNT(['+@v_COLUMN_NAME+']) from '+@DataTable) print @vCount This is my stored procedure part to find the count of a column specified.But here i m getting a conversion error vCount is declared as int

[David Skelly]

I think that you may stand more chance of getting an answer to this if you post in the Database forum.