• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Tuple and domain calculus

In these calculus's (databse calculus), how do you deal with if statements?
0
JCW2
Asked:
JCW2
1 Solution
 
derekkrommCommented:
can you give an example?

typically, when you're writing a query and you need to have an "if" on a specific column, there's a function that allows you to do that

in access, you can do iif(<if statement>, <true value>, <false value>)
in sql server, you can do case when <if statement=true> then <do stuff> else <do other stuff> end

etc
0
 
JCW2Author Commented:
Thank you for your help.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now