Find List of Columns Updated inside Trigger
This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.
2014-02-10 (first published: 2012-06-06)
1,548 reads
Delete Duplicates in SQL 2000, SQL 2005, SQL 2008 or Higher
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,224 reads
Finding other database objects referenced in an SP
Script can be used to find out the objects which are available in other database and are referenced in your stored procedure. These objects will not be listed with sp_depends system stored procedure.
2007-07-31 (first published: 2006-11-21)
265 reads
Blogs
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Top Azure Synapse Analytics and Power BI questions
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Forums
Index scan
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
why cannot use ClientProcessID to trace data in SQL Server Profile.
A C/S system is running on a SQL Server database, and I get its...
Copying an Azure SQL Database with PowerShell
Comments posted to this topic are about the item Copying an Azure SQL Database...
Ask SSC