Sending data from one table to another with the deleted command

Question

Sending data from one table to another with the deleted command

Navigation

#1 by (2 votes)

4

I'm creating this trigger in SQL Server , but I'm not getting the id to send the data to another table and delete this table.

CREATE TRIGGER MoveComprador
ON comprador
INSTEAD OF DELETE
AS
BEGIN
  SELECT * INTO bk_comprador FROM comprador WHERE comprador.codigo = deleted;
END
GO

sql sql-select sql-server query trigger

asked by anonymous 19.06.2015 / 06:31

1 answer

String reading problem How to change the color of a FLAT-UI select without using less?

score 2 · Answer 1

You need to set the "affected" column in the DELETE you want to get.

In this case, use the statement "deleted. YourColumn".

Below is a T-SQL script for you to adapt to your needs:

CREATE TRIGGER MoveComprador
ON comprador
INSTEAD OF DELETE
AS
BEGIN
  DECLARE @ID  int
  SELECT @ID = deleted.id FROM deleted;

  INSERT INTO TB_LOG (CD_REGISTRO, NM_ACAO) VALUES (@ID, 'EXCLUIDO');

END

GO

For more information see:

link