counting the number of rows & displaying columns that are not nul

[Guest]

Hi Guys

i wanted to find out, what is the sql statement i need to count the number
of rows in search query and also the statement i need for displaying columns
that are not null

I'm writing this statement within vb.net

Thank you

 

[RBM007]

Hi Guys
Hi,

i wanted to find out, what is the sql statement i need to count the number
of rows in search query

SELECT COUNT(*) FROM [tablename] WHERE [your where statement]

and also the statement i need for displaying columns
that are not null

SELECT [some columns] FROM [tablename] WHERE [a column] IS NOT NULL

I'm writing this statement within vb.net

Make use of the SqlCommand in the System.Data.Sql package.

Thank you

Hopefully it helped you.

 

[Guest]

Thank you, its working now

Hi Guys Hi,

i wanted to find out, what is the sql statement i need to count the number
of rows in search query

SELECT COUNT(*) FROM [tablename] WHERE [your where statement]

and also the statement i need for displaying columns
that are not null

SELECT [some columns] FROM [tablename] WHERE [a column] IS NOT NULL

I'm writing this statement within vb.net

Make use of the SqlCommand in the System.Data.Sql package.

Thank you

Hopefully it helped you.