Skip to content

Instantly share code, notes, and snippets.

@pascencio
Last active September 27, 2017 06:29
Show Gist options
  • Save pascencio/9054e12c8c5875586f05392aae7c6c08 to your computer and use it in GitHub Desktop.
Save pascencio/9054e12c8c5875586f05392aae7c6c08 to your computer and use it in GitHub Desktop.
Transac-SQL output parameter example (http://sqlfiddle.com/#!6/c0e58/3/0)
-- Validamos que el procedimiento existe
IF OBJECT_ID ( 'spHelloWorld', 'P' ) IS NOT NULL
-- Si existe lo eliminamos para evitar el error al crear
DROP PROCEDURE [dbo].[spHelloWorld];
GO
CREATE PROCEDURE [dbo].[spHelloWorld](
@name VARCHAR(100)
,@code INT OUTPUT -- Debe ser referenciado como '@code'
,@message VARCHAR(100) OUTPUT -- Debe ser referenciado como '@message'
)
AS
BEGIN
SET @code = 1
SET @message = 'Hello ' + @name
END
declare @name VARCHAR(100) = 'John Doe'
declare @local_code INT
declare @local_message VARCHAR(100)
execute spHelloWorld
@name -- Parametro de entrada
, @code = @local_code OUTPUT -- Parametro de salida cargado en @local_code
, @message = @local_message OUTPUT -- Parametro de salida cargado en @local_message
select @local_code as code, @local_message as message
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment