in/out in stored procedure?

Question

Hi All, Can we use in/out parameter in stored procedure? can we use input and output parameter in one declaration? Thanks All Ashok

Jayesh Agrawal · Answer

Ashok, Yes, we can use in/out parameter with stored procedure. By default parameter is in parameter and for out parameter you need to use out keyword. Please refer this nice article to know how we can use it : https://www.codeproject.com/articles/794765/sql-server-how-to-write-stored-procedures-with-out Hope it will helpful for you.

Ravi Kiran Chanduri · Answer

Hi Ashok, We can use out params in SQL .. I have prepared a sample on how to crate it and how to use it . Create Proc GetDetailsAndEMPsecretCode ( @EmpID int , -- Input Param @SecretCode VARCHAR (100) OUTPUT -- Output Param ) AS BEGIN Select * from dbo.EMP where EMPID=@EMpId -- applying some logic and and assigning secret code to @secretcode select @SecretCode=SCD from EMPSecretCode Where EMPID=@EMpId END -- Execution Declare @SC VArchar (100) Exec GetDetailsAndEMPsecretCode 12345,@SC output print @SC

Shahriar Nikkhah · Answer

Some few samples https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/ http://searchsqlserver.techtarget.com/tip/Examples-of-SQL-Server-stored-procedures-and-parameters

in/out in stored procedure?

Answers (3)