ServerConnection.ExecuteScalar Method (String)

Executes a Transact-SQL statement and returns the first column of the first row as an object value.

Espace de noms: Microsoft.SqlServer.Management.Common
Assembly: Microsoft.SqlServer.ConnectionInfo (in microsoft.sqlserver.connectioninfo.dll)

Syntaxe

'Déclaration
Public Function ExecuteScalar ( _
    sqlCommand As String _
) As Object

public Object ExecuteScalar (
    string sqlCommand
)

public:
Object^ ExecuteScalar (
    String^ sqlCommand
)

public Object ExecuteScalar (
    String sqlCommand
)

public function ExecuteScalar (
    sqlCommand : String
) : Object

Paramètres

sqlCommand
A String value that specifies the Transact-SQL command to be executed.

Valeur de retour

An Object system object value that specifies the first column of the first row of the result set.

Notes

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Sécurité des threads

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