SqlScriptDOM
SqlScriptDOM copied to clipboard
microsoft
ScriptDOM/SqlDOM is a .NET library for parsing T-SQL statements and interacting with its abstract syntax tree
We have listed out the examples in Azure Synapse Dedicated SQL Pool that are currently not supported in `Microsoft SQL Parser ( TSql160Parser )` **Version - 170.28.0** ### Microsoft documentation...
**Version - 170.28.0** The following [query](https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?toc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Ftoc.json&bc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fbreadcrumb%2Ftoc.json&view=azure-sqldw-latest&preserve-view=true#k-add-a-primary-key-with-resumable-operation) mentioned in [ALTER TABLE (Transact-SQL)](https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?toc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Ftoc.json&bc=%2Fazure%2Fsynapse-analytics%2Fsql-data-warehouse%2Fbreadcrumb%2Ftoc.json&view=azure-sqldw-latest&preserve-view=true) reports the following error while parsing using `TSql160Parser` . Tried it with `TSql160Parser`, as well as `150` and `140`,...
I'm trying to convert a project over from SqlParser, because SqlParser lacks support for some things I'm trying to parse and it doesn't have source available. But I've hit a...
ScriptDom version: 161.9142.1 Compatibility level: 150 While trying to implement custom TSQL linter rule which should prevent developers from using non-conventional data type names ([synonyms](https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-type-synonyms-transact-sql?view=sql-server-ver16)) I've faced an issue: ScriptDom...
ScriptDom version: 161.9142.1 Compatibility level: 150 Sample code: ```sql SET DATEFIRST 7; ``` FirstTokenIndex of the whole SET command is always equal to the parameter first token index. It should...
ScriptDom version: 161.9142.1 Compatibility level: 150 Sample code: ```sql CREATE PROCEDURE foo WITH EXECUTE AS OWNER AS; ``` Here for the [ExecuteAsClause](https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.transactsql.scriptdom.executeasclause?view=sql-dacfx-160) instance values of FirstTokenIndex and LastTokenIndex are equal...
ScriptDom version: 161.9142.1 Compatibility level: 150 After parsing a `MERGE` statement [MergeActionClause](https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.transactsql.scriptdom.mergeactionclause?view=sql-transactsql-161) instance has the same FirstTokenIndex as it's property - `Action` (for example, `ValuesInsertSource` instance); in case if there...
Inline indices are represented in ScriptDom as instances of [IndexDefinition](https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.transactsql.scriptdom.indexdefinition?view=sql-transactsql-161) class. These index definitions in T-SQL can only be a part of CREATE TABLE/DECLARE TABLE statement and cannot be used...
The change #158 added NotLike to the list of BooleanComparisonType. However, LIKE is not part of that list, so neither should NotLike. This is causing issues in our random query...
- MSSQL Extension Version: 1.28.0 - VSCode Version: 1.98.0 (user setup) - OS Version: Windows_NT x64 10.0.19045 **Problem Description:** I am using the SQL Database Projects extension with MSSQL. I...
