Q&A for spacecraft operators, scientists, engineers, and enthusiasts
Declare @Tag VARCHAR(255); Set @Tag = '<jquery>'; Select Top(50000) @Tag As Tags, Body, ViewCount From Posts Where ViewCount > 1000 And CHARINDEX(@Tag, Posts.Tags) > 0 And (CHARINDEX('<code>', Body) > 0 Or CHARINDEX('<pre>', Body) > 0) Order By ViewCount Desc