Posted by
Andy Brown
on 16 February 2018
You can use the IIF function in SQL as an alternative to the CASE WHEN statement. We thought we would share this new (for us) discovery with the world!
Posted by
Andy Brown
on 02 March 2017
When you are programming in SQL, you often have the choice of using table variables or temporary tables. This blog considers whether one method is substantially quicker than the other (spoiler alert: not really).
Posted by
Andy Brown
on 03 February 2017
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.
Posted by
Andy Brown
on 01 February 2017
A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.
Posted by
Andy Brown
on 27 September 2016
If you want to group items in a SQL query, showing a comma-delimited list of ids for each, generating an XML file is not the obvious place to start - but it should be.
Posted by
Andy Brown
on 23 March 2016
It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.
Posted by
Andy Brown
on 01 February 2016
CTEs (or Common Table Expressions) allow you to divide complicated queries up into two or more simple discrete tasks, as this blog explains.
Posted by
Andy Brown
on 01 February 2016
It's not often that this owl learns new things about SQL when giving a course, but when I do, I like to share my new knowledge! This blog shows a new way to create aliases for columns in SQL.
Posted by
Andrew Gould
on 09 June 2014
Using the Pivot operator in SQL Server allows you to create basic pivot tables from your query results. This blog teaches you how to create simple, static pivots, crosstab-style tables and exciting, dynamic pivot tables.
Posted by
Andrew Gould
on 27 November 2013
Triggers are special stored procedures that execute automatically in response to certain events in a database. This blog explains how to create three types of trigger in SQL Server: DML, DDL and Logon triggers.
Posted by
Andrew Gould
on 11 October 2013
This blog examines how to use Transactions in Microsoft SQL Server to allow you to control when data changes are committed to the database. You'll also discover how you can rollback transactions, effectively giving you the chance to undo changes to your data.
Posted by
Andy Brown
on 06 June 2013
This blog gives the low-down on how to start and use the debugger included in SQL Server Management Studio 2008 R2 and SSMS 2012.
Posted by
Andrew Gould
on 08 May 2013
This blog teaches you how to modify existing data in your database by either deleting records or updating them.
Posted by
Andy Brown
on 03 May 2013
You can use BEGIN TRY to trap errors from SQL Server 2005 onwards, and also raise your own errors using RAISERROR or THROW - this blog explains all!
Posted by
Andy Brown
on 03 May 2013
For the sake of completeness, this blog explains how to join to the results of table-valued functions (like a correlated subquery on steroids).
Posted by
Andrew Gould
on 26 April 2013
This blog teaches you how to return values from your SQL stored procedures using two different techniques: return codes, and output parameters.
Posted by
Andrew Gould
on 22 April 2013
Dynamic SQL is a technique for building valid SQL statements from separate pieces of text. You can use this technique to create remarkably flexible and useful queries, as long as you're aware of the potential danger of SQL injection attacks.
Posted by
Andrew Gould
on 08 April 2013
A derived table is a technique for creating a temporary set of records which can be used within another query in SQL. You can use derived tables to shorten long queries, or even just to break a complex process into logical steps.
Posted by
Andrew Gould
on 26 March 2013
Cursors allow you to step through a set of data one record at a time. They’re not the quickest tool in SQL Server’s box, but they have their uses and this blog explains how they work.
Posted by
Andrew Gould
on 18 February 2013
Many programming languages feature a variety of types of loop which allow your programs to repeat a set of instructions multiple times. In SQL there is only one type of loop, and this blog explains how it works!