when clause
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: when clause

  1. #1
    Join Date
    May 2002
    Posts
    232
    Hiii,any one can give syntax for when clause,if possible with example
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287

  4. #4
    Join Date
    May 2002
    Posts
    232
    Hiii thanks,
    i want to use when clause in query?
    i need to check (x column value) value,
    if it is null i like to increment by 1 else 0 etc
    thanks
    kavitha

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That's not what WHEN is used for. I suggest you take a look at a basic SQL book.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    laff...

  7. #7
    Join Date
    May 2002
    Posts
    232
    hii,i have some other conditions,when is second condition.
    i mean in a particular table i want to display total count as well as one column value will be incremented depending on old value.
    my question is i want to declare a variable in query and i want to increment in when clause.
    how?
    thanks
    kavitha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width