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
没有评论:
发表评论