mercredi 24 août 2016

How to pass stored procedure's parameter values to temp table using MS SQL 2005?

I need to store the procedures acutal parameter values to a temp table. I tried to create a script which can be applied for different stored procedures, therefore the script cannot contain the name of the parameters. This is the code I made, however when I try to store the value of parameters one by one in a temp table, I get error message saying the parameter have to be declared. Please help how to solve this one.

ALTER PROCEDURE [dbo].[EQSP_Parameters] (@MIC varchar(4), @ISIN varchar(12), @Client varchar(12), @TradeDate datetime, @Email int )

Aucun commentaire:

Enregistrer un commentaire