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,547 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,220 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
Using Visual Studio Code
I’m a creature of habit. I have my routine when I get to my...
Docker Containers and Persistent Data
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Cursor Dynamic SQL
By Vinay Thakur
Today was working on SQL Server cursor standard cursor deification would be like this:...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
SSRS Enterprise vs Standard Edition
I need to install SSRS for report development and deployment. I don't work with...
Suspended session
Hi, Application service is going to hung state and when we check the database,...
Ask SSC