Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create trigger Atualiza_Idade
- on cliente
- for insert,update,delete
- as
- declare
- @i int,
- @dtnasc datetime ,
- @Idade int,
- @Hoje DATETIME,
- @Condicao int
- Set @i=1
- Set @Hoje=(SELECT GETDATE ( ))
- while (@i<(select COUNT( *) from Cliente ))
- begin
- select @dtnasc=DataNasimento,@Idade=Idade from Cliente where id=@i;
- set @Condicao = (SELECT FLOOR(DATEDIFF(DAY, @dtnasc, @Hoje) / 365.25));
- if (@Condicao<>(select idade from Cliente where id=@i))
- update Cliente set Idade=@Condicao where id=@i;
- set @i=@i+1;
- end
- go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement