成功创建了触发器 无法使用(已解决)

代码如下
use lab
go
create trigger delete_students_users on lab_students
for delete
as
declare @a varchar(50)
select @a=user_ID from deleted
delete lab_users where user_ID like @a
数据库如下
lab_users表 lab_students表
user_num int(自动编号) stu_num int(自动编号)
user_ID varchar user_ID varchar
user_name char user_name char

[此贴子已经被作者于2007-5-25 18:06:55编辑过]