SQL SERVEUR EXEMPLE DE FUNCTION TABLE

Exemple /// ALTER FUNCTION dbo.EXT_TEST ( @pcvid int, @CODETVA int ) RETURNS @PCV TABLE (CODETAXE int, PTVBASETVA real,PTVMNTTVA real,PTVTAUXtVA real) AS BEGIN insert into @PCV Select CODETAXE, PTVBASETVA, PTVMNTTVA, PTVTAUXtVA FROM PIECEVENTETAXES INNER JOIN PIECEVENTES ON PIECEVENTETAXES.PCVID = PIECEVENTES.PCVID Where PIECEVENTETAXES.PCVID = @pcvid AND PIECEVENTETAXES.CODETAXE = @CODETVA; RETURN; END ///