Create a random string with fixed characters using SQL

Recently I needed to recreate a large number of 8 character alpha-numeric access codes in a customers database as users where confusing certain characters i.e. 1/l and 0/O. I wanted to avoiding doing a code deployment to »


SQL Server Management Studio Keyboard Shortcuts

It can be a bit of a pain when writing long SQL statements when you want to check a table for data. Some people write the full 'Select' statement, some use the side bar, I use a keyboard shortcut to »