Microsoft SQL Server

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4 (6)

2019-11-04

5,086 reads

Generic trigger for maintaining the Audit Log

  • Script

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

584 reads

Blogs

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

New Power BI Report Design Pre-Con in 2020

By

I’m excited to announce that I will be offering a full-day pre-con about Power...

Read the latest Blogs

Forums

From Source Control to Database using SQL Compare Command Line

By Additional Articles

Comments posted to this topic are about the item From Source Control to Database...

The Schema Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Schema Name

The Login Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Login Types, which is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers