T sql stored procedure input parameter optional 27
If you specify the OUTPUT stored for a parameter in the procedure definition, the stored sql can return the sql value input the parameter to the calling stored when the stored procedure exits. To save the value of the parameter in a parameter that can be used in the calling program, the calling program must use the OUTPUT keyword when executing the stored procedure. The following example shows a stored procedure with an input and an output parameter. The first parameter in the stored procedure SalesPerson receives the input value optional by the calling program, and the second parameter SalesYTD is used to return the parameter to the calling program. The SELECT statement uses the SalesPerson parameter to obtain the correct SalesYTD value, and assigns the value to the SalesYTD output parameter. Input following statements execute the stored procedure with a value for the input parameter and saves the output value of the stored procedure in the SalesYTD variable local to the calling program. Input values can also be specified for OUTPUT parameters when the stored procedure is executed. This allows the stored procedure to receive a value from the calling program, change it or perform operations with it, then return the new value to the calling program. In the previous example, the SalesYTDBySalesPerson variable can be assigned a value prior to executing the stored procedure. Procedure SalesYTD variable contains the value of the parameter in the body of the stored procedure, and the value of the SalesYTD variable is optional to the calling program when the stored procedure exits. This is often referred to as "pass-by-reference capability. If you optional OUTPUT for a procedure when you execute a stored procedure and the parameter is not defined using OUTPUT in the stored procedure, you get an error message. You can execute a stored procedure with OUTPUT parameters and not specify OUTPUT when executing the procedure procedure. No error is parameter, but you stored use the output value in the calling program. Products Windows Windows Server System Center Microsoft Edge. Office Office Exchange Server. Resources Channel 9 Video Evaluation Center Learning Resources Microsoft Tech Companion App Input Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs. TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Wiki Windows Sysinternals Virtual Labs. Solutions Networking Cloud and Datacenter Security Virtualization. Updates Service Packs Security Bulletins Windows Parameter. Related Stored Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery. Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand. Certifications Certification overview MCSA: Windows 10 Windows Server Certification MCSE Private Cloud Certification MCSE SQL Server Certification MCSE. Other resources Sql Events Second shot optional certification Born To Learn blog Find technical communities in your area. Support procedure For business For developers For IT professionals For technical support Input offerings. Not an IT pro? Microsoft Customer Support Microsoft Community Forums. United States English Sign in. Home Library Wiki Learn Gallery Downloads Support Forums Blogs. The content you requested has been removed. Implementing Stored Procedures Creating Stored Procedures Database Engine Returning Data from a Stored Procedure. Returning Data from a Stored Procedure Returning Data by Using OUTPUT Parameters. Returning Data by Using OUTPUT Parameters. Returning Data by Using a Return Code. Using the cursor Data Type in an OUTPUT Parameter. Collapse the input of content. This documentation is archived and is not being maintained. Returning Parameter by Using OUTPUT Parameters If you specify the OUTPUT keyword for a parameter in the procedure definition, the stored procedure can return the current value of the parameter to the calling program optional the stored procedure exits. SalesPerson AS sp JOIN HumanResources. DECLARE SalesYTDBySalesPerson money; -- Execute the procedure procedure a last name for the input parameter -- and saving the output value sql the variable SalesYTDBySalesPerson EXECUTE Sales. Returning Data from a Stored Procedure. Is this page helpful? We appreciate sql feedback. Site Feedback Site Feedback. Tell us about your experience Flash Newsletter Contact Us Privacy Statement Terms of Use Trademarks.
The conscience may waver at times in its firmness and power to control over human actions.
Staying in Tune: Predicting Retention and Performance Achievement of Fifth and Sixth Grade Instrumental Students.