Procédures stockées

Créer une procédure

USE [DbName]
GO
/****** Object:  StoredProcedure [dbo].[Etudiant_FindByNote]    Script Date: 02/24/2009 19:20:28 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
 
CREATE PROCEDURE [dbo].[Etudiant_FindByNote]
(
    @EtudiantId int,
    @Note int
)
AS
    SELECT [Etudiant].*
    FROM [dbo].[Etudiant]
    INNER JOIN dbo.[Notes] ON dbo.[Etudiant].[Id] = dbo.[Note].[EtudiantId]
    WHERE [Etudiant].[Id] = @EtudiantId
    AND [Note].[Valeur] > @Note