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,221 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
Understanding Azure Geo-Redundant Storage
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
Prompt in ADS
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention...
Forums
Xquery help please (XML into SQL table)
Hi everyone, any help with the below would be appreciated - see sample data...
Restart cumulative totals to 0 at the change of subsets in a sql table.
I have a dataset that I want to track the number of cars, trucks,...
Azure DB newbie trying to locate existing Azure DBs
Hello, I've been tasked with trying to learn more about existing Azure DBs that...
Ask SSC