SqlScriptDOM
SqlScriptDOM copied to clipboard
microsoft
ScriptDOM/SqlDOM is a .NET library for parsing T-SQL statements and interacting with its abstract syntax tree
static method is added to parser to create an instance and there's not needed to keep the create method. but it can only be obsolete when we change major version....
.NET Framework (Windows-only) or .NET Core: .NET 8 Environment (local platform and source/target platforms): net8.0-windows x64 Steps to Reproduce: Create a visitor inheriting from TSqlFragmentVisitor Override ExplicitVisit(AssignmentSetClause node) Override ExplicitVisit(WhereClause...
ScriptDom version: 161.9123 Parser compatibility level: 150 Code example ``` END CONVERSATION @handle; ``` Actually, I noticed it on a longer IF-ELSE-END CONVERSATION piece of code, but here is the...
CREATE EXTERNAL TABLE [stg].[my_table] ( [COLUMN_ONE] VARCHAR (50) NULL, [filepath] AS CAST(filepath() AS NVARCHAR(1024)), [filename] AS CAST(filename() AS NVARCHAR(1024)) ) WITH ( DATA_SOURCE = [DataSource1], LOCATION = N'somepath/somefile*.csv', FILE_FORMAT =...
- SqlPackage or DacFx Version: latest - .NET Framework (Windows-only) or .NET Core: .NET 8 - Environment (local platform and source/target platforms): net8.0-windows x64 **Steps to Reproduce:** ``` using Microsoft.SqlServer.TransactSql.ScriptDom;...
- SqlPackage or DacFx Version: 162.2.111 - .NET Framework (Windows-only) or .NET Core: net8.0 - Environment (local platform and source/target platforms): Win11&Server 2019 **Steps to Reproduce:** -- SSMS> USE MASTER;...
- SqlPackage or DacFx Version: - .NET Framework (Windows-only) or .NET Core: .NET 8 - Environment (local platform and source/target platforms): net8.0-windows x64 **Steps to Reproduce:** 1. Create a visitor...
Currently the generator only generates one newline between statements which leads to code like this: ```sql CREATE TABLE [MyTable] ( ... ); ALTER TABLE [MyTable] ...; ``` Which can be...
The TSql160Parser incorrectly identifies the interval parameter in the DATEDIFF function as a ColumnReferenceExpression. This issue occurs when parsing expressions like `DATEDIFF(mm, ColA, ColB)`. Reproduction Steps: 1. Use the following...
