1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
ALTER PROCEDURE [dbo].[CheckingPass]
@login AS NVARCHAR(50),
@pass AS NVARCHAR(50),
@role AS nvarchar(50)
AS
BEGIN
declare @sqlstring1 nvarchar(50)
declare @id as int
set @sqlstring1= ( select idpersonne from personne
where [login] =@login )
set @id = exec @sqlstring1 --erreur ici
declare @sqlstring nvarchar(200)
print @id
set @sqlstring = ('select count(idpersonne) from ' + @role + ' where statut = 1 and idpersonne = + @id)
print @sqlstring
exec sp_executesql @sqlstring
END |
Partager