1er jours du Préparation Sur le Forum TDI

[Mr.Rachid]

Rappel du premier message :

1er jours du Préparation Sur le Forum TDI

[nizarawi]

ok jatt toi merciiiiiii

[nona]

Code:

create trigger T1
on operation
for insert
as
declare @montant float
set @montant = (select montant from inserted)
declare @solde float
set @solde=(select compte.solde from compte inner join inserted on compte.numcpt=inserted.numcpt)
declare @typeop varchar(1)
set @typeop=(select typeop from inserted)

declare @numcpt int
set @numcpt=(select inserted.numcpt from inserted inner join compte on inserted.numcpt=compte.numcpt inner join client on compte.numcli=client.numcli)
if (  @typeop='C' )
begin
update compte set solde=solde+@montant where numcpt=@numcpt
end
else
if( @montant < @solde and @typeop='D')
begin
update compte set solde=solde-@montant where numcpt=@numcpt
end
else
rollback tran

chof had l example wach fhemtih
+ 3ndi des cours ila bghitihom + exposé
=>wa7d information : trigger se declanche automatiquement
ya3ni fach katcééyh kaykhdem meme si f lvb machi just 3la lsql

[nona]

wach kat3ref dir deploiement f lvb ; ila kat3ref gol liya les etaps merci

[nizarawi]

ouiii fhamto mercii bcp
mais ila kan plus dexplication par des cours et expose ikon 7ssan

merci bcp pour les informations

pour depoloiement mazal madkhalnach l had module
mais kayna hadik dial propriete dial projet o siri l menu publier
deploiement basic mais machi howa li mtlob fi exam

[nona]

1/wéé ana bghit had deploiment 7it bghito lwa7d application c hors deploiment diyal l examen mais mal9itch had deploiemennt basic 3ndi wach kathder 3la dak l menu fach kayn application,compiler,....refrence....hada mafihch hadi li galti
2/pour les cours ila 3ndk boit gmail ansifthom lik prcq mafiya mayrf3hom l net + net t9ila 3ndi
ok

[Contenu sponsorisé]