Partager via


Méthode ExecuteScalar

Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Ne référencez pas directement ce membre dans votre code. Il prend en charge l'infrastructure SQL Server.

Espace de noms :  Microsoft.SqlServer.Management.Sdk.Sfc
Assembly :  Microsoft.SqlServer.Management.Sdk.Sfc (en Microsoft.SqlServer.Management.Sdk.Sfc.dll)

Syntaxe

'Déclaration
Public Shared Function ExecuteScalar ( _
    connection As ServerConnection, _
    script As String _
) As Object
'Utilisation
Dim connection As ServerConnection
Dim script As String
Dim returnValue As Object

returnValue = SfcTSqlExecutor.ExecuteScalar(connection, _
    script)
public static Object ExecuteScalar(
    ServerConnection connection,
    string script
)
public:
static Object^ ExecuteScalar(
    ServerConnection^ connection, 
    String^ script
)
static member ExecuteScalar : 
        connection:ServerConnection * 
        script:string -> Object 
public static function ExecuteScalar(
    connection : ServerConnection, 
    script : String
) : Object

Paramètres

Valeur de retour

Type : System. . :: . .Object
The first column of the first row in the result set, or a null reference if the result set is empty. Returns a maximum of 2033 characters.