Archive for January 21st, 2009
SQL 2000 Font!
Posted by in Accessibility, SQL Server on January 21, 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.
Single Character Wildcards
Posted by shawson in SQL Server on January 21, 2009
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