There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.

Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

by Gregory Larsen

SQLServerCentral.com

No one wants to use more keystrokes than they have to when they write a chunk of T-SQL code. To help with minimizing the number of characters a T-SQL developer needs to type the Microsoft team introduced three new shortcuts operators when they release SQL Server 2008. These shorts cuts are the String Concatenation, Add EQUALS, and the Subtract EQUALS operators.

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

by Gregory Larsen

SQLServerCentral.com

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.

Stairway to XML: Level 1 - Introduction to XML

by Rob Sheldon

SQLServerCentral.com

In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations

Stairway to XML: Level 2 - The XML Data Type

by Rob Sheldon

SQLServerCentral.com

Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype

Stairway to XML: Level 4 - Querying XML Data

by Rob Sheldon

SQLServerCentral.com

You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.

Stairway to SQL Server Reporting Services

Tablix Tutorial – Level 4 in the Stairway to Reporting Services

by Jessica M. Moss

SQLServerCentral.com

This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.

The Basics of SSRS - Level 2 in the Stairway to Reporting Services

by Jessica M. Moss

SQLServerCentral.com

In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.

The Basics of SSRS - Level 2 in the Stairway to Reporting Services

by Jessica M. Moss

SQLServerCentral.com

In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services

by Andy Leonard

SQLServerCentral.com

Part four of this stairway series examines the process of updating the data in an existing table in a load. MVP Andy Leonard talks about the way in which packages can handle changes in a repeatable fashion.

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

Stairway to XML: Level 1 - Introduction to XML

Stairway to XML: Level 2 - The XML Data Type

Stairway to XML: Level 4 - Querying XML Data

Tablix Tutorial – Level 4 in the Stairway to Reporting Services

The Basics of SSRS - Level 2 in the Stairway to Reporting Services

The Basics of SSRS - Level 2 in the Stairway to Reporting Services

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services

Blogs

A New Word: the Kinder Surprise

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Forums

There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

SSoL Support on the OS

Question of the Day

SSoL Support on the OS