Triggers

SQLServerCentral Article

PostgreSQL Triggers Part 2

  • Article

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

2022-09-23

808 reads

External Article

Triggers: Threat or Menace?

  • Article

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.

2017-01-03

3,807 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Calculate log space required on principle for maintenance activity

By ramana3327

Hi all, We have a database configured for asynchronous mirroring. We have some planned...

Get a Date Time Stamp of table when another columns value changes.

By lalitprg2017

I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime]...

how to write a query by using some filter patterns in SQL Server?

By maifs

what I want is to apply some filter patterns to search the data. For...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers