Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION vente.fn_NbCommandes
- (@numfou int)
- RETURNS int
- AS
- BEGIN
- DECLARE @nb int
- SET @nb= (select count(*) from vente.entcom
- where numfou = @numfou)
- if @nb=0 print Aucune commande pour le founisseur
- else print commandes pour le founisseur
- RETURN @nb
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement