Auditing Solution - Generate Triggers automatically

The procedure looks at the table you want to be audited and writes the INS, UPD, and DEL triggers automatically required for the auditing to work. The auditing requires a table called Progress to hold the audit information in so have provided the DDL for this as well. Typically you would write a cursor to […]

2002-02-04

464 reads

Procedure Search by Keyword(s)

Searches SysComments for occurances of entered keywords and returns a list of procedures that contain the keywords. eg1) To find all procedures with 'nMyColumn' in EXEC utl_ProcSearch 'nMyColumn' eg2) To find all procedures with 'nMyColumn' in and 'nMyColumn2' in EXEC utl_ProcSearch 'nMyColumn', 'nMyColumn2' eg3) To find all procedures with temporary tables in... EXEC utl_ProcSearch '#' […]

2002-02-04

182 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

RTO 15 minutes with differential backups

By DBANewbie

Hi. I'm working through the official exam reference book for 70-764 by Isakov and...

Towards an efficient interface between application and database

By Phil Factor

Comments posted to this topic are about the item Towards an efficient interface between...

How to handle date on temp table when is null or not ?

By ahmed_elbarbary.2010

How to handle date on temp table when is null or not ? I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers