MSSQL Tutorial: Search code inside of stored proceedures
DECLARE @SEARCHSTRING VARCHAR(255), @notcontain Varchar(255) SELECT @SEARCHSTRING = ‘expiration_date =’, @notcontain = ” SELECT DISTINCT sysobjects.name AS [Object Name] , case when sysobjects.xtype = ‘P’ then ‘Stored Proc’ when sysobjects.xtype = ‘TF’ then ‘Function’...
