兩條實用SQL Server Select statement

1. 找尋STORED PROCEDURE內含有的字元

SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%ABC%'


2. 找尋最近修改的STORED PROCEDURE及TABLE

Select * from sys.objects
order by modify_date desc


以上兩條SQL都是我常用的,對Merge Code及Debug時非常有幫助,希望幫到大家