lukemurray / data-atom

Query and manage data sources from Atom
MIT License
152 stars 36 forks source link

Parse GO in Transact SQL #34

Open chrisblatchley opened 9 years ago

chrisblatchley commented 9 years ago

I'm aware this may be a point of contention when it comes to dealing with t-sql since the GO statement is specifically a Management Studio construct. However, I think it would be useful as many of my scripts (and likely others working with SQL Server) are for creating/updating functions and stored procedures which executing batches.

This feature is to add parsing of T-SQL scripts that include the GO statement to be split into multiple batches and executed. I believe the tds adapter this project is using supports batches, so maybe this is a feasible feature to add.

lukemurray commented 9 years ago

Agreed. This is on my list as I use management studio at work and have maybe scripts with GO in them. Just thinking about the best way to handle this.

On Fri, Nov 6, 2015 at 3:24 AM, Chris Blatchley notifications@github.com wrote:

I'm aware this may be a point of contention when it comes to dealing with t-sql since the GO statement is specifically a Management Studio construct. However, I think it would be useful as many of my scripts (and likely others working with SQL Server) are for creating/updating functions and stored procedures which executing batches.

This feature is to add parsing of T-SQL scripts that include the GO statement to be split into multiple batches and executed. I believe the tds adapter this project is using supports batches, so maybe this is a feasible feature to add.

Reply to this email directly or view it on GitHub: https://github.com/lukemurray/data-atom/issues/34