Archive for January 21st, 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