If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

ScriptDomVisualizer - Now Displays TSqlParserTokens

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script.

Honestly if you are doing anything with the T-SQL Script Dom this is really useful to help reverse engineer t-sql into ScriptDom objects :)

Grab it from:

https://github.com/GoEddie/ScriptDomVisualizer/tree/master/release

Enjoy!


Comments:

Anonymous

December 10, 2015 - 14:05

Recently I have been working

Recently I have been working on a task to split multi columns/constraint alter statement into separate statements (one alter for each column/constraint).
I couldn’t manage to convert it from string statement into DOM object so I used regexp and substrings. But if it happen to change this code again I will use your approach.

Ed Elliott

December 10, 2015 - 14:07

Cool, the more samples and

Cool, the more samples and demos we have for this sort of thing the better :)

Subscribe

* indicates required

Please select all the ways you would like to hear from Agile Sql Club:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.