Hello guys, I'm hoping someone can help me. I've been on this for a couple of hours now and cant figure it out. I'm still somewhat of an C#/MS SQL newbie who mostly works with PHP.
I want to search a DB for this:
SELECT COUNT(*) From table WHERE CustId = "12345"
where this should return either a number of rows or NULL if nothing is found (i'm assumming this returns Null instead of zero)
if it returns null or zero do this
if it returns an number greater than zero do this
Can anyone help me out or point me to a good tutorial for this?
Hello guys, I'm hoping someone can help me. I've been on this for a couple of hours now and cant figure it out. I'm still somewhat of an C#/MS SQL newbie who mostly works with PHP.
I want to search a DB for this:
SELECT COUNT(*) From table WHERE CustId = "12345"
where this should return either a number of rows or NULL if nothing is found (i'm assumming this returns Null instead of zero)
if it returns null or zero do this
if it returns an number greater than zero do this
Can anyone help me out or point me to a good tutorial for this?
-Chris
Chris Cummings
Integrity Web Development
Chattanooga Web Service