cs_brute
Messages postés135Date d'inscriptionmercredi 8 novembre 2000StatutMembreDernière intervention11 mai 20071 28 nov. 2005 à 13:41
USE nomdelabdd
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'nomdelaprocedure')
DROP PROCEDURE nomdelaprocedure
GO
CREATE PROCEDURE nomdelaprocedure
@d1 datetime, @d2 datetime, @nomduchamp int OUTPUT
AS
SELECT sum(nomduchamp)AS Qnomduchamp,
FROM STAT_TRI_T2
WHERE Date_Stat BETWEEN @d1 AND @d2;
RETURN
GO