Stored procedure with output parameters and table function?

Question

Which approach is better to use if I need a member (sp or func) that returns 2 parameters:

CREATE PROCEDURE Test
   @in INT,
   @outID INT OUT,
   @amount DECIMAL OUT
AS
BEGIN
   ...
END

or

CREATE FUNCTION Test
(
   @in INT
)
RETURNS @ret TABLE (outID INT, amount DECIMAL)
AS
BEGIN
   ...
END

What are the pros and cons of each approach, given that the result will be passed to another stored procedure:

EXEC Foobar @outID, @outAmount

Answer 1

Function table-assessment only within the same operator can be used SELECT. It cannot execute DML, exclude exceptions, etc.

On the other hand, it can return a set that can be immediately attached to another set of records in the same query.

DML , , proc; TVF.

Answer 2

, :-) , ... , ... ORM, ... , .

, .

.

Answer 3

: @outID @amount.

(outID, amount) . , , , :

SELECT dbo.Test(1) AS TestValues

Answer 4

, . , , , .

Answer 5

- , .

, .

, SP/UDF SELECT - .. Inline Function - SQL Server , - - . , , UDF , , - .

, ; , .

Answer 6

.

. , .

, , udf. , ... udf.

Answer 7

, SP, TBF ( ) , .

, SQL, CURSOR ( , ).