Archive for January, 2009

SQL 2000 Font!

Another simple one which i've only just recently found out- changing the font in the stored procedure viewer under enterprise manager for sql 2000- when in the sql server window, right click and select font.  Then update the "Text" property to the font of your choice and click OK.  This make a permanent change to any future stored procedure windows.

No Comments

Single Character Wildcards

To my shame, I only recently realised there was a single character wildcard available in SQL ( _ ) as well as the mutliple character wildcard ( % )!  really handy for substituting single quote characters (or other weird ones) to ensure a match when doing a ‘like’ lookup

No Comments

2 tabs fresh!

In visual studio 2008 you'll notice a lot of operators such as foreach/ switch etc etc are listed as snippets in the intellisense menu, however when you hit tab to insert them it just autocompletes the keyword- if you hit tab twice it will insert the full snippet, giving you a dummy template usage for that keyword!

No Comments