after触发器

after触发器

use test
go

create trigger stu_Insert on student after insert,update
as
begin
declare @name nvarchar(50);
select @name=name from inserted
if not @name like '%[a-z]%'
rollback Transaction
print '用户名非法'
end
go