For several years I have happily relied on @@IDENTITY to return the latest identity of a row when inserting data. However, I have started using the OUTPUT clause and have discovered the entertainment to be had in getting the latest identity when writing to two or more tables with what can appear to be one …
In a previous posting I described a simple example of Pivot – a much used feature which I personally have problems recalling the syntax of (hence the article in the first place). It’s lesser known relative in UnPivot, which is designed to do the opposite – it transforms columns of data into rows. In the …
I take notes all day long as I work with SQL Server. Short scribbles, brief explanations, small novels – all committed to paper or some electronic format as I go through my professional career. The theory is sound and generally quite useful. Then I find I have so many notes that I have trouble actually …
Notes on SQL 