Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [awroblak]
- GO
- /****** Object: StoredProcedure [dbo].[returnID] Script Date: 2017-06-21 08:26:05 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: <Author,,Name>
- -- Create date: <Create Date,,>
- -- Description: <Description,,>
- -- =============================================
- ALTER PROCEDURE [dbo].[returnID]
- -- Add the parameters for the stored procedure here
- @tableName nvarchar(200),
- @value nvarchar(200)
- AS
- BEGIN
- -- SET NOCOUNT ON added to prevent extra result sets from
- -- interfering with SELECT statements.
- SET NOCOUNT ON;
- -- Insert statements for procedure here
- DECLARE @query nvarchar(500)
- DECLARE @idOUT nvarchar(20)
- DECLARE @id nvarchar(20)
- SET @id = 'id'
- SET @query = 'SELECT ' + @id + ' FROM ' + @tableName + ' WHERE ' + @tableName + ' = ' + '''' + @value + '''' + ';';
- DECLARE @retVal nvarchar(50);
- DECLARE @ParmDefinition nvarchar(500);
- SET @ParmDefinition = N'@idOUT nvarchar OUTPUT';
- PRINT 'Do wykonania: ' + @query
- EXECUTE sp_executesql @Query = @query,
- @Params = @ParmDefinition,
- @idOUT = @retVal OUTPUT;
- PRINT 'Wynik: ' + @idOUT
- --RETURN @idOUT
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement