Invoke-TSqlProcedure

SYNOPSIS

SYNTAX

StoredProcedure (Default)

Invoke-TSqlProcedure [-Procedure] <String> [-Schema <String>] [-Database <String>] [[-Parameter] <Hashtable>]
 [-Timeout <Int32>] [-Connection <SqlConnection>] [<CommonParameters>]

Text

Invoke-TSqlProcedure [-Text] <String> [[-Parameter] <Hashtable>] [-Timeout <Int32>]
 [-Connection <SqlConnection>] [<CommonParameters>]

TextFile

Invoke-TSqlProcedure [-InputFile] <FileInfo> [[-Parameter] <Hashtable>] [-Timeout <Int32>]
 [-Connection <SqlConnection>] [<CommonParameters>]

DESCRIPTION

EXAMPLES

Example 1

PS C:\> 

PARAMETERS

-Connection

Type: SqlConnection
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Database

Type: String
Parameter Sets: StoredProcedure
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-InputFile

Type: FileInfo
Parameter Sets: TextFile
Aliases:

Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Parameter

Type: Hashtable
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Procedure

Type: String
Parameter Sets: StoredProcedure
Aliases:

Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Schema

Type: String
Parameter Sets: StoredProcedure
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Text

Type: String
Parameter Sets: Text
Aliases: Command, Query

Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Timeout

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

System.String

System.IO.FileInfo

System.Collections.Hashtable

System.Nullable`1[[System.Int32, System.Private.CoreLib, Version=5.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]

OUTPUTS

System.Management.Automation.PSObject

NOTES

RELATED LINKS