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