Search my own posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @PostText nvarchar(600) = ##PostText:string##

SELECT @PostText = UPPER(@PostText)
SELECT
    Id AS [Post Link],
    Score AS [Score],
    CreationDate AS [Creation Date]
FROM
    Posts    
WHERE
    OwnerUserId = 960757 AND
    PostTypeId IN (2, 3) AND
    UPPER(Body) LIKE '%' + @PostText + '%'
ORDER BY
    CreationDate
DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results