Query [modified]
-
i have these data in table 'dealer': dealerid@@@campaignid@@@keyvalue @1@@@@@@@@3@@@@@@@6 @2@@@@@@@@4@@@@@@@3 @3@@@@@@@@2@@@@@@@5 @4@@@@@@@@1@@@@@@@4 @5@@@@@@@@1@@@@@@@2 @6@@@@@@@@2@@@@@@@1 @7@@@@@@@@3@@@@<@NULL@> = NULL is null value in database without the '@'sign between brackets '<','>' and 'NULL' '@' = spacebar,to separate the data. Now i want the dealerid where campaignid = 3 n keyvalue = NULL So, i queried in queryanalyzer of sqlserver2005: SELECT dealerid FROM dealer WHERE (keyvalue = NULL) AND (campaignid = 3) I must get output as 7. But i dont get any output in its output window, neither i am getting any error. Hope to get a reply. regards Nekshan. -- modified at 3:17 Wednesday 4th April, 2007
-
i have these data in table 'dealer': dealerid@@@campaignid@@@keyvalue @1@@@@@@@@3@@@@@@@6 @2@@@@@@@@4@@@@@@@3 @3@@@@@@@@2@@@@@@@5 @4@@@@@@@@1@@@@@@@4 @5@@@@@@@@1@@@@@@@2 @6@@@@@@@@2@@@@@@@1 @7@@@@@@@@3@@@@<@NULL@> = NULL is null value in database without the '@'sign between brackets '<','>' and 'NULL' '@' = spacebar,to separate the data. Now i want the dealerid where campaignid = 3 n keyvalue = NULL So, i queried in queryanalyzer of sqlserver2005: SELECT dealerid FROM dealer WHERE (keyvalue = NULL) AND (campaignid = 3) I must get output as 7. But i dont get any output in its output window, neither i am getting any error. Hope to get a reply. regards Nekshan. -- modified at 3:17 Wednesday 4th April, 2007
Your post is illegible. Try keyvalue is null instead of keyvalue = NULL. It's a vagary of SQL, two instances of NULL will not have the same value, so nothing every = NULL.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Your post is illegible. Try keyvalue is null instead of keyvalue = NULL. It's a vagary of SQL, two instances of NULL will not have the same value, so nothing every = NULL.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Christian Graus wrote:
Your post is illegible.
I second
Christian Graus wrote:
Try keyvalue is null instead of keyvalue = NULL
This one I also second.
WHERE keyvalue IS nullshould fix your problem.
Visual Studio can't evaluate this, can you?
public object moo { __get { return moo; } __set { moo = value; } }