SQL Trigger Archives - Page 6 of 6 - SQL Authority with Pinal Dave

Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL Server Interview Questions and Answers – Part 2

April 16, 2007

SQL Interview Questions and Answers

Database, Software Development, SQL Collation, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Server DBCC, SQL Server Security, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 1

April 15, 2007

SQL Interview Questions and Answers

Software Development, SQL Cursor, SQL Download, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Introduction

April 15, 2007

SQL Interview Questions and Answers

Database, DBA, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL SERVER – 2005 – Disable Triggers – Drop Triggers

April 13, 2007

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security, SQL Trigger

There are two ways to prevent trigger from firing. 1) Drop Trigger Example: DROP TRIGGER TriggerName GO 2) Disable Trigger DML trigger can be disabled two ways. Using ALETER TABLE statement or use DISABLE TRIGGER. I prefer DISABLE TRIGGER statement. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name […