SqlScriptDOM
SqlScriptDOM copied to clipboard
microsoft
ScriptDOM/SqlDOM is a .NET library for parsing T-SQL statements and interacting with its abstract syntax tree
I try to format my sql script using `GenerateScript` method but WHERE clause is missing from its output. Nuget version `Microsoft.SqlServer.TransactSql.ScriptDom` `161.9109.0`. Under debug I see parsed WHERE statement. input...
https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/changetable-transact-sql?view=sql-server-ver16 References with any target platform fail to parse (and then build in dacfx) if the changetable function has the 3rd and optional `FORCESEEK` parameter added
ScriptDom version: 161.8919.0 Compatibility level used for parsing: 150 Parser did not fill `Clustered` property and because it is a PRIMARY KEY which are CLUSTERED by default unless explicitly defined...
In this code sample: ``` CREATE TABLE dbo.foo ( bar INT NOT NULL DEFAULT 0 , far VARCHAR(100) NOT NULL , zar DATE PRIMARY KEY (bar, far) ) ``` comma...
- Microsoft.SqlServer.DacFx Version 161.6374.0 - Reproduced on both .NET 6.0 and .NET 7.0 - Windows 11 The `Microsoft.SqlServer.TransactSql.ScriptDom.TSql160Parser` fails to parse the following expression. We noticed the issue on a...
- ScriptDom Version: 161.8910.0 - CompatibilityLevel used for parsing: 150, 160 Some _keywords_ written right next to the transaction control statement are treated as _transaction name_ and some as _a...
I've updated the package to the last version 161.8901.0 but still the new Sql 2022 TSQL syntax "IS [NOT] DISTINCT FROM" is not reconized and results in a syntax error....
SQL Server 2022 introduced a new type of backup - [snapshot](https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-transact-sql-snapshot-backup?view=sql-server-ver16). ScriptDom currently does not support this type of backup. Note that this is different from the database snapshot functionality,...
TSqlParser results in a stack overflow exception when parsing large SQL files containing a lot of UNIONs (example: in a view or stored procedure). Culprit is likely the recursive visitor...
- DacFx Version: Nuget latest (160.6161.0) - .NET: 6.0.301 - Environment (local platform and source/target platforms): linux-x64 **Steps to Reproduce:** 1. parse T-SQL script with GO [count] statement 2. parsing...
