代码如下
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编辑过]

@a都已经是准确值了还用like
like 需要统配符

这就改