This topic has not yet been rated - Rate this topic

TSqlParser.ParseSubQueryExpressionWithOptionalCTE Method (TextReader, IList(ParseError), Int32, Int32, Int32)

SQL Server 2012

Parses an input string to get a subquery expression with optional common table expression and xml namespaces with the specified input reader.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

abstract ParseSubQueryExpressionWithOptionalCTE : 
        input:TextReader * 
        errors:IList<ParseError> byref * 
        startOffset:int * 
        startLine:int * 
        startColumn:int -> SelectStatement

Parameters

input: Type: System.IO.TextReader
The script that will be parsed.

errors: Type: System.Collections.Generic.IList(ParseError)
When this method returns, contains the list of error that occurred during parsing. This parameter is passed uninitialized.

startOffset: Type: System.Int32
The offset where the parse starts. This parameter is passed uninitialized.

startLine: Type: System.Int32
The line number where the parse starts. This parameter is passed uninitialized.

startColumn: Type: System.Int32
The column number in the line where the parse starts. This parameter is passed uninitialized.

Return Value

Type: Microsoft.SqlServer.TransactSql.ScriptDom.SelectStatement
The parsed subquery or null if any errors occurred.

Reference

TSqlParser Class

ParseSubQueryExpressionWithOptionalCTE Overload

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD