AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, February 19, 2009

SQL Formatter

A nice tool SQL and PL/SQL Formatter (actually a web page) to format SQL language (Access, T-SQL, etc) to a number of useful formats – html, VBA, XML, whatever you can imagine. Here how html output looks like for T-SQL:

SELECT tblBill.BillID,
       --tblBill.BillNum,
       tblBill.BillDate
FROM   tblBill
WHERE  Datediff(d,tblBill.BillDate,Getdate()) > @intDays

Labels: ,

0 Comments:

Post a Comment

<< Home