Tag Archives: SQL Server

SQL Server: Using Table Aliases In Delete And Update Queries

A couple of posts ago I said that I would blog about counting unique and distinct values using VBA. I promise I will get to that but today I want to talk about the syntax for using tables aliases in … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , | 1 Comment

The Colour of Null

Today was a learning experience. I’ve been working on a project which partly involved tweaking existing tables and stored procedures in a SQL Server database. I performed some tests between dev and production to make sure I hadn’t messed anything up … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , | 4 Comments