Microsoft and innovation: IIF() method

Posted on Get blogged by JoKi See other posts from Get blogged by JoKi
Published on Sun, 06 Oct 2013 13:10:30 +0000 Indexed on 2013/10/17 16:22 UTC
Read the original article Hit count: 335

Filed under:

Development

This Saturday I was watching a couple of eLearning videos from TrainSignal (thanks to the subscription I have with Pluralsight) on Querying Microsoft SQL Server 2012 (exam 70-461).

'Innovation' by Microsoft

I kept myself busy learning 'new' things about Microsoft SQL Server 2012 and some best practices. It was incredible 'innovative' to see that there is an additional logic function called IIF() available now:

Returns one of two values depending on the value of a logical expression.
IIF(lExpression, eExpression1, eExpression2)

Ups, my bad... That's actually taken from the syntax page of Visual FoxPro 9.0 SP 2. And tada, at least seven (7+) years later, there's the recent IIF() Transact-SQL version of that function:

Returns one of two values, depending on whether the Boolean expression evaluates to true or false in SQL Server 2012.

IIF ( boolean_expression, true_value, false_value )

Now, that's what I call innovation! But we all know what happened to Visual FoxPro... It has been reincarnated in form of Visual Studio LightSwitch (and SQL Server).

Enough ranting... Happy coding!

Related posts about Development

How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
PHP Web Development, Web Development Using PHP As an Open Source

as seen on Ezine Articles - Search for 'Ezine Articles'
PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML. PHP is the most famous language nowadays as it is an open source and web development requires no costs in implementation. >>> More
Small Business Web Site Development - 3 Tips For Getting Business Web Development

as seen on Ezine Articles - Search for 'Ezine Articles'
If your want to grow your Small Business, Web Site Development is a crucial ingredient for this new growth going forward. Web development is more than putting words or content on a web page. Today more than 50% of folks looking for products or services use the internet to find what they needs. Here… >>> More
Surface development: it’s just like software development

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Surface is magic. Everyone using it seems to think that way. And I have to be honest, after working for almost 2 years with the platform I still get that special feeling the moment I turn on the unit to do some more work. The whole user experience, the rich environment of the SDK, the touch, even… >>> More
Desktop development versus Web development

as seen on Stack Overflow - Search for 'Stack Overflow'
What are the advantages and disadvantages of one model and the other? Why and when would you choose one or the other? If you were going to build a business application, which is the best approach for you? To make this a fair question, is better if you post only quantified non-subjective answers. >>> More

Developer IT