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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
| CREATE PROCEDURE Keyword_client
@nom_client VARCHAR(30), @prenom_client VARCHAR(30), @email_client VARCHAR(30), @ville_client VARCHAR(30)
AS
DECLARE @requete VARCHAR(1000)
DECLARE @i INT
SET @i = 0
SET @requete = 'SELECT
id_client,
mdp_client,
email_client,
nom_client,
prenom_client,
date_naissance_client,
date_inscription_client,
rue_client,
cp_client,
ville_client,
supp_adr_client,
tel_client,
gsm_client,
nb_points_cumul_client
FROM
client'
/* nom_client */
IF @nom_client IS NOT NULL
BEGIN
SET @i += 1
IF @i = 1
BEGIN
SET @requete = @requete + ' WHERE '
END
ELSE
BEGIN
SET @requete = @requete + ' AND '
END
SET @requete = @requete + 'nom_client LIKE ''' + @nom_client + '%'''
END
/* prenom_client */
IF @prenom_client IS NOT NULL
BEGIN
SET @i += 1
IF @i = 1
BEGIN
SET @requete = @requete + ' WHERE '
END
ELSE
BEGIN
SET @requete = @requete + ' AND '
END
SET @requete = @requete + 'prenom_client LIKE ''' + @prenom_client + '%'''
END
/* email_client */
IF @email_client IS NOT NULL
BEGIN
SET @i += 1
IF @i = 1
BEGIN
SET @requete = @requete + ' WHERE '
END
ELSE
BEGIN
SET @requete = @requete + ' AND '
END
SET @requete = @requete + 'email_client LIKE ''' + @email_client + '%'''
END
/* ville_client */
IF @ville_client IS NOT NULL
BEGIN
SET @i += 1
IF @i = 1
BEGIN
SET @requete = @requete + ' WHERE '
END
ELSE
BEGIN
SET @requete = @requete + ' AND '
END
SET @requete = @requete + 'ville_client LIKE ''' + @ville_client + '%'''
END
EXEC(@requete)
GO |
Partager