UGMFree
Free resources for developers
Tips in T-SQL
This page is a reminder and how-to for my best tips in TSQL


How to find text in SQL stored procedures

A very fast method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B ON A.id = B.id
WHERE A.text like '%testo da cercare%'
UGM.NET ©2002-2010
By Gianluca Negrelli - Contact me