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,551 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,227 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)
267 reads
Blogs
The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It
By todd-32417
Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!
The Post Pandemic Office Experience
By Steve Jones
I traveled to Pasadena, CA this week to work with a few other Redgaters...
Connecting to Azure Blobs in Power BI
By DataOnWheels
The step-by-step process below walks through connecting to data housed in Azure Blob Storage...
Forums
Get the last day of the year based on a date range
I am trying to get the last day of the year from a date...
Put two queries together
Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...
Excel Formula to create SQL Script for a Values Table
Comments posted to this topic are about the item Excel Formula to create SQL...
Ask SSC