2021年4月1日星期四

trigger on SQL server

I have a code CREATE TRIGGER XOADT ON DETAI FOR DELETE AS BEGIN DECLARE @DT1 CHAR(30) SET @DT1 = (SELECT MSDT FROM DELETED) DELETE FROM SV_DETAI WHERE MSDT=@DT1 DELETE FROM GV_PBDT WHERE MSDT=@DT1 DELETE FROM GV_HDDT WHERE MSDT=@DT1 DELETE FROM HOIDONG_DT WHERE MSDT=@DT1 DELETE FROM GV_UVDT WHERE MSDT=@DT1 END so how to disable foreign key and able foreign key

https://stackoverflow.com/questions/66913320/trigger-on-sql-server April 02, 2021 at 09:08AM

没有评论:

发表评论