杭州交通信息网天刀神威pve装备2017:DELETE触发器
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/29 22:08:35
我做了一个 DELETE触发器，有用但是每次激活就把ky_totaldata表所有的数据删除了，这是为什么呀？谢谢各位大侠帮忙...
CREATE TRIGGER [TRI_NEWSDATA3] ON [dbo].[KY_NEWSDATA]
FOR DELETE
AS
DELETE [dbo].[ky_totaldata]
select KY_ID,KY_DIR,KY_CATA,KY_SOURCE,KY_ZHUANTI,KY_TITLE,KY_HTTP,'101','KY_NEWSDATA'
from deleted
where ky_id= deleted .ky_id
CREATE TRIGGER [TRI_NEWSDATA3] ON [dbo].[KY_NEWSDATA]
FOR DELETE
AS
DELETE [dbo].[ky_totaldata]
select KY_ID,KY_DIR,KY_CATA,KY_SOURCE,KY_ZHUANTI,KY_TITLE,KY_HTTP,'101','KY_NEWSDATA'
from deleted
where ky_id= deleted .ky_id
语句写的有问题吧？
你这个触发器想做什么啊？是不是一个做一个外键的约束
DELETE [dbo].[ky_totaldata] 这不就删除了？
后面为什么要跟个SELECT，如果是条件的话为什么不加WHERE？这应该算是条语句了。
还不加BEGIN..END
应该这么写吧：
delete dbo.ky_totaldata where ky_id=(select ky_id from deleted)