Please Note: This query only searches comments left within the last week or so
Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
Id AS [Comment Link],
CreationDate as Date
text like '%##Word##%' COLLATE SQL_Latin1_General_CP1_CI_AS
CreationDate > '2015-02-22T00:00:00.000'