Numeric padding in T-SQL
I was recently trying to find a way to padding a number in T-SQL and decided to share what I found. Let us say I wanted to pad the number 123 into the string ’00123′, here is how to do it. SELECT REPLACE(STR(123, 5), ‘ ‘, ’0′) FROM SomeTable I found this little bit of [...]
Rename objects in SQL Server
Recently I had to rename some columns and a couple of tables in a database that I work on. Clearly I could go through SQL Server Management Studio and rename them, but I wanted something I could save to a script and run. Ladies and gentlemen, boys and girls, let me introduce a little stored [...]
Simple Mockup Generator – Balsamiq
Lately I have been using Balsamiq Mockups for all of my general mockup needs. They offer both a desktop version and a web version. I have focused mainly on the web version, and I am liking it. While it is simply a demo, it has all of my needs. While you cannot save in the [...]
