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,549 reads
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,549 reads
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,224 reads
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
SQL Server is a complex beast, with many configuration options that can range from...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
How to update table partwithcompany column name company id by companyid for max partid...
Hoe to get appt_time+duration = end_time can you please help on this
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....