Skip to main content

Posts

Showing posts from June, 2013

Modal window effects using CSS transitions and animations

Nifty Modal Window Effects offer many possibilities for modal overlays to appear using CSS transitions and animations.

MSSQL: Get All Stored Procedures With References to a Table

AFAIK, there is no built-in feature to generate a list of stored procedures that made references to a specific database table. The following help me to do just that.

SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id AND so.xtype = 'P' WHERE sc.TEXT LIKE '%TABLE_NAME%'