This topic has not yet been rated - Rate this topic

TSql100Parser.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. This will return null, if there were any errors.

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

Syntax

C++

JScript

public override function ParseSubQueryExpressionWithOptionalCTE(
	input : TextReader, 
	errors : IList<ParseError>, 
	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.

startOffset: Type: System.Int32
The starting offset.

startLine: Type: System.Int32
The starting line.

startColumn: Type: System.Int32
The starting 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

TSql100Parser 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