--use dbn_4_tutby;

select * from users

--create trigger T_users_I
--	on users
--	for insert
--	as
--		begin
--			declare @name varchar(80)
--			select @name = name from inserted

--			if @name like '%xxx%'
--				begin
--					print ( 'не могу добавить запись с именем ' + @name )
--					rollback tran
--				end
--			else
--				print ( 'Запись добавлена' )
--		end

insert into users (name, user_status, access, email)  values ('xxxxx', 0, 1, 'xxxk@here.by')
alter table users
	disable trigger T_users_I




create trigger T_users_U
	on users
	for update
	as
		begin
			select * from inserted
			select * from deleted
		end

select * from users

update users
	set name = 'ZMICER'
	where id > 11