The Microsoft.SqlServer.TransactSql.ScriptDom namespace provides Microsoft SQL Server-specific Parser and Script Generator support.
Questions tagged [scriptdom]
23 questions
0
votes
0 answers
Microsoft.SqlServer.TransactSql.ScriptDom for CosmosDb?
Is there a Microsoft library for parsing and manipulating CosmosDB parse trees a la Microsoft.SqlServer.TransactSql.ScriptDom for SQL server?
nh43de
- 813
- 11
- 11
0
votes
2 answers
Normalize SQL Query Text in c#
I executed the following query in the SQL Server database.
SELECT * FROM Production.Product WHERE Name = 'Bearing Ball'
Then I tried to get the query text along with the statistics using the following SQL command :
SELECT
qs.sql_handle,
…
Deepan
- 95
- 7
0
votes
6 answers
The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Transact-SQL ScriptDom is installed
Web deployment task failed.
(The SQL provider cannot run because of a missing dependency. Please make sure that Microsoft SQL Server Transact-SQL ScriptDom is installed.
I get this error while publishing any web app in visual studio with update…
irfandar
- 1,690
- 1
- 23
- 24
0
votes
1 answer
Create a visitor for generic statement in TransactSql.ScriptDom
With TransactSql.ScriptDom, it is possible to view object model of an SQL statement by extending the TSqlFragmentVisitor class. For each statement type, there is a separate Visit method which can be overridden. But I want to put exactly the same…
Pavel Sinkevich
- 619
- 5
- 12
0
votes
1 answer
"as" keyword considered confusing in TSql100Parser code
Suppose I want to parse the sql statement
SELECT foo, bar, baz FROM myTable WHERE baz = 2 ORDER BY baz ASC, bar DESC
and programmatically determine the columns and directions it's ordering by. After some googling, here's what I've come up…
Roman Zabicki
- 214
- 2
- 4
- 14
0
votes
0 answers
Get the data type of a FunctionCall such as scope_identity()
If I have an instance of Microsoft.SqlServer.TransactSql.ScriptDom.FunctionCall, how do I get the data type of the value that will be returned by the function?
adam0101
- 29,096
- 21
- 96
- 174
0
votes
1 answer
How to get SelectStatement from Procedure?
This is a follow up question from here. I'm trying to use DACExtensions to retrieve the SelectStatement objects from a Procedure so that I can generate wrapper functions from my SSDT project using a T4 template. The problem is that the Nodes…
adam0101
- 29,096
- 21
- 96
- 174
-1
votes
1 answer
How can I write new T-SQL script with ScriptDom and changed columns?
I would like to build T-SQL parser which will be building new queries for different DBMS with specific rules. First rule which would like to implement is to add to every column name ' at the beginning and end of column name.
I get code from below…
adam.g
- 101
- 3