- 8 Week Game
- Quick Ref
Archive for January, 2009
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.
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
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!