Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What are IN and OUT parameter in SQL Server

What are IN and OUT parameter in SQL Server?

like image 600
NoviceToDotNet Avatar asked Nov 07 '10 08:11

NoviceToDotNet


1 Answers

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

like image 199
Jagmag Avatar answered Sep 30 '22 00:09

Jagmag