CODEWITHSUNDEEP
sql-serversql-server-2005t-sql
NoviceToDotNet
NoviceToDotNet

Reputation: 10815

What are IN and OUT parameter in SQL Server

What are IN and OUT parameter in SQL Server?

Upvotes: 6

Views: 31878

Answers (1)

Jagmag
Jagmag

Reputation: 10366

IN Parameters - parameters that pass data TO a stored Procedure

OUT Parameters - parameters that are used to RETURN data FROM a stored procedure

Refer MSDN for more details on procedures with IN and OUT params and how to use them

Examples of how IN/OUT are used with TSQL can be found here: SQL Server Stored Procedure Basics

Upvotes: 13

Related Questions