Tuple and domain calculus

Posted on 2011-03-06
Medium Priority
Last Modified: 2012-05-11
In these calculus's (databse calculus), how do you deal with if statements?
Question by:JCW2
LVL 15

Accepted Solution

derekkromm earned 2000 total points
ID: 35050912
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


Author Closing Comment

ID: 35059489
Thank you for your help.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question