Update Trigger Example Sybase - Hallo there Sarah Server reader, this time we will talk about Update Trigger Example Sybase, We have prepared this article for you, hope you enjoy this Guide, Happy reading.

Title : Update Trigger Example Sybase
link : Update Trigger Example Sybase

Update Trigger Example Sybase

create trigger empdata_to_upd_empage on empdata
for update
as
if update (empid)
begin
update empage set empage.empid = inserted.empid
from
inserted,empage,deleted
where deleted.empid=empage.empid
end

(1 row affected)
(return status = 0)
1> select * from empdata
2>
empname empid
-------------------- -----------
k 654
m 76
o 6
t 98
w 65
(5 rows affected)
1> select * from empage
2>
empid empage
----------- -----------
654 23
76 45
6 43
98 29
65 60
(5 rows affected)

1> update empdata set empid=100 where empname='t'
2>
(1 row affected)
1> select * from empdata
2>
empname empid
-------------------- -----------
k 654
m 76
o 6
t 100
w 65
(5 rows affected)
1> select * from empage
2>
empid empage
----------- -----------
654 23
76 45
6 43
100 29
65 60
(5 rows affected)
1>

There is Update Trigger Example Sybase

Thus article Update Trigger Example Sybase this time, hope can give benefits to all of you. well, see you in other post.

You are reading Update Trigger Example Sybase with link https://saraserver.blogspot.com/2010/01/update-trigger-example-sybase.html