use *Databasenaam*
if exists
(select name from sysobjects
where name = 'SP_insert_controle_instrument_partituur' and xtype = 'p')
drop procedure SP_insert_controle_instrument_partituur
go
create procedure SP_insert_controle_instrument_partituur
@Titel varchar(80) = '',
@Componist varchar(80) = '',
@Instrumentnaam varchar(80) = '',
@Gelukt VARCHAR(20) OUTPUT
as

IF EXISTS (SELECT * FROM dbo.Partituur WHERE Titel = @Titel AND Componist = @Componist AND Orkestpartituur = 1) AND EXISTS (SELECT * FROM Orkest.Instrument WHERE Naam = @Instrumentnaam)
	BEGIN
		INSERT INTO Orkest.Voor
		VALUES (@Titel, @Componist, @Instrumentnaam)
		SET @Gelukt = 'OK'
	END
ELSE
	BEGIN
		SET @Gelukt = 'Foutmelding'
	END