Tag Archives: SQL

Coding NATO International Radiotelephony Alphabet in SQL

Joe Celko and Ken Henderson are two of my favourite SQL Gurus and I very much enjoyed reading one of Joe’s articles this morning. It made me think and playing with the code was fun. Try this on for size: … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

SP (Stored Procedure) Audit script for SQL Server 2005

I needed a script that showed the last change in time for the stored procedures in my database so I came up with the following. Certain of you may find it useful. Please comment if you have ideas for improvements. … Continue reading

Posted in Miscellany | Tagged , , , | 2 Comments

Query to return table rowcounts & identity values in SQL Server

Sometimes when you are doing administrative or investigative work in your database you need to get an up-to-date idea of the the row count and Identity key values (for those tables having them). I created the following script to this … Continue reading

Posted in Miscellany | Tagged , , | 2 Comments

Using a ‘zero’ row in SQL Server tables

At first I rebelled against the very idea of doing this but I was eventually convinced and now all my tables have zero rows. This doesn’t mean there are no rows in the tables, this means that whenever I create … Continue reading

Posted in Miscellany | Tagged , , | Leave a comment

Using Excel to generate Inserts for SQL Server

Much of my day job involves database design, maintenance and manipulation. I use SQL scripts to quickly build my databases from scratch. In order to test them I need piles of data and find it is often too much work … Continue reading

Posted in Miscellany | Tagged , , , , | 32 Comments