I'm gonna need a bigger axe
-
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
-
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
that ain't be a problem if you were writing it on VB. :-\
-
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
Start with installing Notepad++, go to the plugin manager and add "Poor Man's T-SQL Formatter" It's not perfect, but it becomes fairly readable
Wrong is evil and must be defeated. - Jeff Ello
-
Start with installing Notepad++, go to the plugin manager and add "Poor Man's T-SQL Formatter" It's not perfect, but it becomes fairly readable
Wrong is evil and must be defeated. - Jeff Ello
I'm just going to dump everything in a cell in excel and just point to that cell when doing a query. The readability problem isn't really a formatting problem but rather a comprehension problem. But since the returned results are enough for me to work with I'll just do what I need post query to present a report and sweep everything under a nice big rug and home for the best. :) I did panic first when I saw the extent of the query until I realised that I could work around it. I can honestly say that if I would have to dissect the query it would take two weeks non stop and that's being optimistic.
-
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
Only 11,000? Have you seen some of the SQL queries Entity Framework can put together for you? 11K is nothing.
A guide to posting questions on CodeProject
Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak -
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
I've found that the best thing to do with such queries is print them out, run them through a shredder, and use the shredded paper to light a barbecue.
I wanna be a eunuchs developer! Pass me a bread knife!