Database part 4

TRIGER UPDATE


create database anggota

use anggota

go
create table teman
(
id_ang char (5),
nama char (20) not null,
umur tinyint
)



go
create trigger UpdateData
on teman
for update
as
  print 'data telah di ubah'
 
insert into teman values ('S09', 'shanyndita', 22)

update teman
set nama = 'shinci'
where id_ang = 'S09'

select * from teman