What are IN and OUT parameter in SQL Server

Question

What are IN and OUT parameter in SQL Server?

Answer 1

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