ServerConnection.NormalizeQuery Method

Definition

Namespace:

Microsoft.SqlServer.Management.Common

Assembly:

Microsoft.SqlServer.ConnectionInfo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

NormalizeQuery(String, Boolean)	Translate a query with embedded literals to a normalized form (all literals replaced by a standard token)
NormalizeQuery(String)	Overload for the above function -- see it for details

NormalizeQuery(String, Boolean)

Translate a query with embedded literals to a normalized form (all literals replaced by a standard token)

public static string NormalizeQuery (string QueryText, bool QuotedIdentifiers);

static member NormalizeQuery : string * bool -> string

Public Shared Function NormalizeQuery (QueryText As String, QuotedIdentifiers As Boolean) As String

Parameters

QueryText

String

Query text to normalize

QuotedIdentifiers

Boolean

Switch indicating whether query text expects QUOTED_IDENTIFER to be enabled

Returns

String

Query text with inline literals translated to ? symbols

Remarks

Examples:

SELECT * FROM table WHERE column = 123

becomes:

SELECT * FROM table WHERE column = ?

SELECT * FROM table WHERE column = 'foo'

becomes:

SELECT * FROM table WHERE column = '?'

NormalizeQuery(String)

Overload for the above function -- see it for details

public static string NormalizeQuery (string QueryText);

static member NormalizeQuery : string -> string

Public Shared Function NormalizeQuery (QueryText As String) As String

Parameters

QueryText

String

Returns

String