Triggers

External Article

SQL Server 2000: .NET and the Death and Re-Birth o

  • Article

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.

2001-07-27

1,538 reads

Blogs

Introduction to Advanced Analytics

By

The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.

A New Word: Feresy

By

feresy – n.  the fear that your partner is changing in ways you don’t...

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

How can Azure consulting help maximize my business's cloud strategy and ensure s

By saramartin90

I’m exploring Azure consulting services to enhance my cloud strategy, but I’m curious about...

Migrating standalone database to always-on cluster.

By JasonO

I am planning to migrate a currently standalone database to SQL Always On. This...

Visit the forum

Question of the Day

AUTO_DROP Statistics

In SQL Server 2022, what does this statement do?

CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ON

See possible answers