after触发器

2015-07-24 08:40:23 · 作者: · 浏览: 3
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

?