|
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.
(comments are locked)
|
|
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. Hi Grant, Thanks for response. actualy i want to make create my own tool. so for this i requrire some intiall help from your side guys... so if any one give me some brief idea it will much appriciated.
Feb 09 '12 at 03:46 PM
shalabh21
(comments are locked)
|
|
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. I did a quick google search and found the following links: Google CodeProject Devioblog Hi Hemanth, actaully i want to do some thing special for my company in and some innovative
Feb 09 '12 at 03:47 PM
shalabh21
Hi, I think you will not receive much help from here as this site is related to the SQL Server and not the General Development. AS @hemanth.damecharla mentioned, you should take a look on sites like Code Project, Stack Overflow etc. To achieve really good formatting, it's quite complex task.
Feb 09 '12 at 06:11 PM
Pavel Pawlowski
thanks pavel...
Feb 09 '12 at 07:36 PM
shalabh21
(comments are locked)
|
