我有一个存储过程,其中包含一个值:
BEGIN TRY
BEGIN TRANSACTION;
-- Insert statements for procedure here
DECLARE @return_value int
DECLARE @media_id uniqueidentifier
'INSERT SQL STATEMENT HERE
SELECT [media_id] FROM [media] WHERE 1 = 1
-- One row affected
RETURN 1
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
-- Rollback, no row affected
RETURN 0
END CATCH;
我想从另一个存储过程中调用[media_id]的值。我该如何获取这个值?