This topic has not yet been rated - Rate this topic

NonQueryResult Class

SQL Server 2012

Represents the results from a call to the ExecuteNonQuery method.

System.Object
Microsoft.SqlServer.Management.MultiServerConnection.ResultInfo
Microsoft.SqlServer.Management.MultiServerConnection.NonQueryResult

Namespace: Microsoft.SqlServer.Management.MultiServerConnection
Assembly: Microsoft.SqlServer.Management.MultiServerConnection (in Microsoft.SqlServer.Management.MultiServerConnection.dll)

public sealed class NonQueryResult : ResultInfo

The NonQueryResult type exposes the following members.

	Name	Description
	BatchStartingLine	Gets the starting line of the batch in the editor. (Inherited from ResultInfo.)
	BatchText	Gets the text of the Transact-SQL batch that was executed. (Inherited from ResultInfo.)
	CompletedSuccessfully	Gets True if execution was successful, False if there was an exception. (Inherited from ResultInfo.)
	ConnectionInfo	Gets the connection info of the connection producing the result. (Inherited from ResultInfo.)
	Exception	Gets or sets the exception that was thrown while executing the Transact-SQL. (Inherited from ResultInfo.)
	ExecutionTime	Gets or sets the amount of client wall-time it took to get the result back from the server. (Inherited from ResultInfo.)
	LoginName	Gets the name of the login executing the batch. (Inherited from ResultInfo.)
	RowsAffected	Gets or sets the number of rows that are affected by the ExecuteNonQuery method.
	ServerDisplayName	Gets the display name of the server where the batch was executed. (Inherited from ResultInfo.)
	ServerName	Gets the name of the server where the batch was executed. (Inherited from ResultInfo.)
	StartTime	Gets or sets the time when the batch was submitted. (Inherited from ResultInfo.)

	Name	Description
	Equals	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	ToString	Gets the string representation of the current object. (Overrides Object.ToString().)

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions