This topic has not yet been rated - Rate this topic

TSql90Parser.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 (CTE) and XML namespaces.

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  
override 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 start offset.

startLine: Type: System.Int32
The start line.

startColumn: Type: System.Int32
The start column.

Return Value

Type: Microsoft.SqlServer.TransactSql.ScriptDom.SelectStatement
The subquery expression with optional common table expression and XML namespaces if parsing succeeded; a null reference (Nothing in Visual Basic) if errors occurred during parsing.

Reference

TSql90Parser 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