Out Parameters in SQL server/Oracle

Question

Can we write multiple out parameters in SQL server/Oracle if yes please write one example..

Hemant Srivastava · Answer

Yes we can write A simple example: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE dbo.MultipleOutputParameters ( @P_Id INT @LastName VARCHAR(50) OUTPUT @FirstName VARCHAR(50) OUTPUT @City VARCHAR(50) OUTPUT ) AS BEGIN SELECT @LastName = LastName @FirstName = FirstName @City = City FROM dbo.ADDRESS WHERE P_Id = @P_Id END GO