How do I accurately handle a batch seperator for SQL from C#
- by Sam Saffron
For Data Explorer I would like to add support for a Batch separator.
So for example if users type in:
select 'GO' go select 1 as go
Go
select 100
I would like to return the three result sets.
Its clear that I need some sort of parser here, my hope is that this is a solved problem and I can just plug it in. (writing a full T-SQL parser is not something I would like to do)
What component / demo code could achieve splitting this batch into its 3 parts?