Hi All, Warm wishes from shalabh saxena.
I want to make a SQL script formatter using C#,ASP DOT NET. Can any one give me breif idea about this. Fairly say i do not know much about this even how to start on this. i just have good knowledge of C#, ASP DOT NET and SQL 2008.
Please give me clear idea.
asked Feb 09, 2012 at 02:35 PM in Default
There are already a number of tools out there that do this. You might want to take a look at them. There's SSMS Tools Pack, TSQL Prettifier, and my company's product, SQL Prompt. I think there are a couple of others as well. The first two in the list are free.
answered Feb 09, 2012 at 03:35 PM
Grant Fritchey ♦♦
I am not sure why you would want to attempt such a complex task but, if you are still going to do it anyways, then the starting point would be to parse the given SQL and validate that it is correct and then tokenize it into keywords.
answered Feb 09, 2012 at 03:45 PM