Delete en cascada
Publicado por Paloma (7 intervenciones) el 04/09/2009 23:51:24
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER DEPURA_BITACORA
ON Bitacora
AFTER DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT * FROM BITACORA WHERE vis_id IN(
SELECT vis_id FROM Visitas
)
-- -- BORRA COMENTARIOS
IF DELETED
BEGIN
DELETE FROM COMENTARIOS HERE vis_id IN(
SELECT vis_id FROM Visitas
)
END
GO
En la seccion de borra comentarios me manda error
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER DEPURA_BITACORA
ON Bitacora
AFTER DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT * FROM BITACORA WHERE vis_id IN(
SELECT vis_id FROM Visitas
)
-- -- BORRA COMENTARIOS
IF DELETED
BEGIN
DELETE FROM COMENTARIOS HERE vis_id IN(
SELECT vis_id FROM Visitas
)
END
GO
En la seccion de borra comentarios me manda error
Valora esta pregunta
0
