Skip to content

Support for OUTPUT Parameters of Stored Procedures #12

@abbgrade

Description

@abbgrade

Return data using an output parameter requires currently a workaround like

Invoke-TSqlCommand -Query @"
DECLARE @SalesYTDBySalesPerson money;

EXECUTE Sales.uspGetEmployeeSalesYTD  
    N'Blythe', @SalesYTD = @SalesYTDBySalesPerson OUTPUT;  

SELECT @SalesYTDBySalesPerson AS SalesYTDBySalesPerson;  
"

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    Status

    To do

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions