What is the IN and OUT parameter in SQL Server

Question

What is INand OUTparameter in SQL Server?

Answer 1

IN Parameters - parameters that pass data to the stored procedure

OUT Parameters - parameters used to return data from a stored procedure

See MSDN for more information on procedures with IN and OUT parameters and how to use them.

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