SqlScriptDOM
SqlScriptDOM copied to clipboard
microsoft
ScriptDOM/SqlDOM is a .NET library for parsing T-SQL statements and interacting with its abstract syntax tree
Adding a new test to verify the bug in #91
Could we consider exposing the generator visitor classes as public classes to allow people to fine tune generation. This would make it so if someone really desires they can generate...
 As shown above, this configuration is only taken into account when generating the body of a view statement. However there are other places such as below where it should...
Using `Microsoft.SqlServer.TransactSql.ScriptDom` version `161.9135.0`. For example: ```sql select 1 option(recompile) ``` gets parsed as: ``` TOKENS: 0: Select "select" 1: WhiteSpace " " 2: Integer "1" 3: WhiteSpace "\n" 4:...
# Description *Please provide a detailed description. Be as descriptive as possible - include information about what is being changed, why it's being changed, and any links to relevant issues....
## Issue When using XML or JSON `FOR` clauses in subqueries, the `FirstTokenIndex` of `XmlForClause` and `JsonForClause` objects incorrectly pointed to the first option token (typically `PATH`) instead of the...
The following SQL is accepted as valid and works as intended by SQL Server. ```sql CREATE TABLE DummyTable ( col int, INDEX INDEX_ON_COL (col) WHERE (col) IS NOT NULL )...
ScriptDom version: 161.9142.1 Compatibility level: 150 Sample code: ```sql SELECT * FROM dbo.foo FOR XML PATH(''), ROOT ('x'), TYPE SET @x = (SELECT * FROM dbo.foo FOR XML PATH(''), ROOT...
## Script ```sql USE MyDB GO SELECT Id, DATEADD(DAY, 1, GETDATE()) FROM Table1 GO SELECT DATEADD(DAY, 1, GETDATE()) ``` The 2nd query does not select from a table, but also...
Scripts may contain SQLCMD variables and other SQLCMD syntax. Currently TSql150Parser reports it as an error. This repository demonstrates the current behavior: https://github.com/marvhen/SqlScriptDomSqlcmdSyntax
