Using the TSQL IIF Function
Here is a quick video tutorial on how to use the IIF function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part… Read More »Using the TSQL IIF Function
IIF
SQL Training – Functions (70-461)
In this presentation we will be training on TSQL Functions, there will be three sections. Date and Time Functions Logical Functions User Defined Functions Here… Read More »SQL Training – Functions (70-461)
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and… Read More »SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Happy Birthday SQL Server 2012
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary.… Read More »Happy Birthday SQL Server 2012
SQL Server 2012 IIF Statement
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of… Read More »SQL Server 2012 IIF Statement
Sessions submitted to SQL Saturday Vancouver BC
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run… Read More »Sessions submitted to SQL Saturday Vancouver BC
My Top 10 TSQL Enhancements in SQL Server 2012
So far after playing around with SQL Server 2012 there are many new features to SQL. Overall I think my favorites are in the Analytic… Read More »My Top 10 TSQL Enhancements in SQL Server 2012
IIF in TRANSACT SQL on SQL SERVER 2012
For years I have heard the question of how can I do an IIF in TSQL? Honestly I never thought it would be that useful… Read More »IIF in TRANSACT SQL on SQL SERVER 2012
4 Sessions Submitted to Seattle Code Camp
It has been a busy week getting ready for SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present.… Read More »4 Sessions Submitted to Seattle Code Camp