blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL » Formatting code
  • SQL: Using the Trim function to remove white space from a field

    Today I was looking at a table with an apparantly empty column and discovered that the field is actually populated with blank spaces - Fortunately this field is of no interest to me and I noticed it purely by chance when I pasted an extract of the dat into excel and happened to notice the cell was unusually wide when I formatted the sheet. Anyway, ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on August 14, 2007
  • Automatically format your SQL statements

    A colleague forwarded me this link today, which I thought would be beneficial to anyone who has to write a lot of SQL statements. The tool will automatically format the statements to 'beautify' them, so no more excuses for 'ugly' code! Check it out here James
    Posted to Jim 2.0 (Weblog) by James.Pipe on August 9, 2007
Powered by Community Server (Personal Edition), by Telligent Systems