Archives quotidiennes : 20 juin 2015

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…

Exemple : /// select * from ( SELECT P.PINCODE AS TYPEDOC, P.PCVNUM AS NUMDOC, P.PCVDATEEFFET AS DATEDOC, T.TIRCODE AS CODECLIENT, A.ADRSOCIETE AS NOMCLIENT, A.ADRVILLE AS VILLE, P.PCVNUMEXT AS NUMEXT, P.PCVMNTHT…