Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE #inputParams (ParamName VARCHAR(20), ParamValue VARCHAR(20))
- INSERT INTO #inputParams (ParamName, ParamValue) VALUES ('First Name', 'John')
- INSERT INTO #inputParams (ParamName, ParamValue) VALUES ('Last Name', 'Doe')
- EXEC dbo.USP_MyStoredProcedure
- CREATE PROCEDURE dbo.USP_MyStoredProcedure AS
- DECLARE @FirstName VARCHAR(20)
- SET @FirstName = SELECT ParamValue FROM #inputParams WHERE ParamName = 'First Name'
- GO
- CREATE PROCEDURE MyDynamicStoredProc
- @ParameterXML XML
- AS
- SET NOCOUNT ON
- DECLARE @Parameter1 NVARCHAR(50)
- DECLARE @Parameter2 INT
- SET @Parameter1 = @ParameterXML.value('/Root/Parameters/StringParameter/@Value','nvarchar(50)')
- SET @Parameter2 = @ParameterXML.value('/Root/Parameters/IntegerParameter/@Value','int')
- ...
Add Comment
Please, Sign In to add comment