CREATE TRIGGER [CheckXS] ON [dbo].[XS] FOR DELETE AS delete from XS_KC where XH in(select XH from deleted)
SQL+parser 源代码
汇集 SQL+parser 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
--表'groupuser'的结构 if exists (select * from sysobjects where id = OBJECT_ID('groupuser') and OBJECTPROPERTY(id, 'IsUserTable') =…
--表'groupuser'的结构 if exists (select * from sysobjects where id = OBJECT_ID('groupuser') and OBJECTPROPERTY(id, 'IsUserTable') =…
--表'jyxxb'的结构 if exists (select * from sysobjects where id = OBJECT_ID('jyxxb') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP…
--表'sx'的结构 if exists (select * from sysobjects where id = OBJECT_ID('sx') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE…
--表'tslb'的结构 if exists (select * from sysobjects where id = OBJECT_ID('tslb') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP T…
--表'qxgl'的结构 if exists (select * from sysobjects where id = OBJECT_ID('qxgl') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP T…
--表'jyxxb'的结构 if exists (select * from sysobjects where id = OBJECT_ID('jyxxb') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP…
--表'tsjbxx'的结构 if exists (select * from sysobjects where id = OBJECT_ID('tsjbxx') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DR…
--表'sx'的结构 if exists (select * from sysobjects where id = OBJECT_ID('sx') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE…