CREATE TRIGGER xx ON [dbo].[group]
FOR DELETE
AS
declare @Group_Id char(20)
select @Group_Id=Group_id from deleted
delete from class where Group_Id= @Group_Id
FOR DELETE
AS
declare @Group_Id char(20)
select @Group_Id=Group_id from deleted
delete from class where Group_Id= @Group_Id
解决方案 »
- SQL2000远程连接服务器的问题
- 修改sa密码后,作业调度包失败,包的密码已修改 什么原因 再线等 谢谢
- 怎样用vb.net 代码获取SQL Server 的存储过程的参数名称和参数类型
- 请教1简单的查询语句
- MS SQL SERVER的各个版本之间(企业,标准...)的区别,该怎么选择呢?
- mysql function 返回值问题 给100分 急急急 在线等
- 为什么我安装SQLSERVE的时候,安装界面老是出不来??????
- SQL 查询 分从另外的地方出
- 关于触发器的问题????
- sql id分段查询
- sql有没有分散的函数阿?
- 关于记录某字段不能重复,而其他可以为空的查询问题,帮忙一下,谢谢,效率要高点的。
as
delete from student where class_id in (select class_id from class where groupid in (select group_id from deleted))delete from class where groupid in (select group_id from deleted)
on group
for delete
as
delete from student a
inner join class b
on a.class_id=b.classid
inner join deleted c
on b.group_id= c.group_id delete from class a inner join deleted b on a.group_id=b.group_id