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
?
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
?