Q&A for people studying math at any level and professionals in related fields
DECLARE @keyword AS NVARCHAR(60) = ##keyword:string? ##; DECLARE @pauthor AS INT = ##PostAuthor:int?-1## SELECT p.Id AS [Post Link], 'site://q/' + Convert(VarChar(10), p.Id) + '#comment' + Convert(VarChar(10), p.Id) + '_' + Convert(VarChar(10), c.Id) + '|' + c.Text AS [Comment], c.Score AS [Score], p.CreationDate AS [Post date], c.CreationDate AS [Comment date] FROM Posts p INNER JOIN Comments c ON c.PostId = p.Id WHERE p.OwnerUserId = @pauthor AND c.Text LIKE N'%' + @keyword + '%' COLLATE Latin1_General_100_CI_AI_SC_UTF8 ORDER BY c.CreationDate