Invoke-SqlServerQuery

NAME Invoke-SqlServerQuery



SYNTAX

Invoke-SqlServerQuery -SqlQuery <SqlQuery> [-Credential <pscredential>] [-ConnectionTimeout <int>] [-Database

<string>] [-Server <string>] [-ConnectionString <string>] [-NoTrans] [-WhatIf] [-Confirm] [-UseTransaction]

[<CommonParameters>]



Invoke-SqlServerQuery -Sql <string> [-Parameters <hashtable>] [-Credential <pscredential>] [-CommandTimeout <int>]

[-ConnectionTimeout <int>] [-Scalar] [-CUD] [-StoredProcedure] [-Database <string>] [-Server <string>]

[-ConnectionString <string>] [-NoTrans] [-ExpectedRowCount <int>] [-Callback <scriptblock>] [-WhatIf] [-Confirm]

[-UseTransaction] [<CommonParameters>]





PARAMETERS

-CUD



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-Callback <scriptblock>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-CommandTimeout <int>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-Confirm



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases cf

Dynamic? false



-ConnectionString <string>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-ConnectionTimeout <int>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-Credential <pscredential>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-Database <string>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-ExpectedRowCount <int>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-NoTrans



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-Parameters <hashtable>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-Scalar



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-Server <string>



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases None

Dynamic? false



-Sql <string>



Required? true

Position? Named

Accept pipeline input? true (ByValue, ByPropertyName)

Parameter set name Default

Aliases None

Dynamic? false



-SqlQuery <SqlQuery>

Use New-SqlQuery to create a SqlQuery object.



Required? true

Position? Named

Accept pipeline input? true (ByValue)

Parameter set name SqlQuery

Aliases None

Dynamic? false



-StoredProcedure



Required? false

Position? Named

Accept pipeline input? false

Parameter set name Default

Aliases None

Dynamic? false



-UseTransaction



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases usetx

Dynamic? false



-WhatIf



Required? false

Position? Named

Accept pipeline input? false

Parameter set name (All)

Aliases wi

Dynamic? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).





INPUTS

InvokeQuery.SqlQuery

System.String





OUTPUTS

System.Object



ALIASES

None





REMARKS

None