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

No comments:

Post a Comment