Q&A for developers and researchers interested in open data
DECLARE @searchText NVARCHAR(100) = '%sk-ant-api03-%' DECLARE @dateFrom DATETIME = '2024-03-01' -- YYYY-MM-DD DECLARE @dateUntil DATETIME = '2024-04-10' -- YYYY-MM-DD -- Searching in Posts SELECT Body FROM Posts WHERE Body LIKE @searchText AND CreationDate >= @dateFrom AND CreationDate < @dateUntil