摘要:
阅读全文
摘要:
我对SQL触发器不是很了解,但是最近要用到它,所以就上网查了一下。会写一些比较简单的了。在这里做一个记录,以便以后自己使用 CREATE TRIGGER deletName ON [dbo].[a] FOR DELETE AS begin delete from b where classid = (select id from deleted) end 第一句,de... 阅读全文
摘要:
select * from C_admin where id in (select max(id) as id from C_admin group by admin_name) 阅读全文