I have a store procedure like this:
CREATE PROCEDURE up_action
(@id int
,@group varchar(30)=''
,@nom varchar(30)=''
,@compte varchar(30)=NULL
)
AS
BEGIN
DECLARE @chrono int
......
select @date=date from users where compte=@compte
INSERT INTO dialog
(numappel,auteur,commentaire,etape,etapews,operant)
VALUES
(@numappel,@nomprenom,@dialogue,14,14,@nomoperateur)
SET @chrono = SCOPE_IDENTITY()
select 'chrono'=@chrono
END
I want to call this store procedure from an application written in C# with the possibility to give the parameters separated by , (actually their values) and after that to receive eventually a record set rs from wich i can get the value of the variable like rs("chrono").
I know the possibility with creating every parameter and telling the type, the name, the value etc. But I want a method like in ASP because I have procedures with 100 parameters ...