SóProvas


ID
3520483
Banca
VUNESP
Órgão
IPSM
Ano
2018
Provas
Disciplina
Banco de Dados
Assuntos

Considerando o sistema gerenciador de bancos de dados SQL Server 2012, no tipo de trigger

Alternativas
Comentários
  • FOR or AFTER specifies that the DML trigger fires only when all operations specified in the triggering SQL statement have launched successfully. All referential cascade actions and constraint checks must also succeed before this trigger fires. You can't define AFTER triggers on views.

    INSTEAD OF Specifies that the DML trigger launches instead of the triggering SQL statement, thus, overriding the actions of the triggering statements. You can't specify INSTEAD OF for DDL or logon triggers.

    .

    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15

  • dica: quando não souber o parâmetro correto, tente traduzir as palavras em inglês

  • kkkk acertei so pelo ingles