5

Please login or register to vote for this query.

(click on this box to dismiss)

This displays all posts and comments on Stack Overflow for a particular user.

Q&A about the site for serious players and enthusiasts of chess

-- Get all your posts and comments
-- This displays all posts and comments on Stack Overflow for a particular user.

(select CreationDate, Title, Body, PostTypeId from Posts where OwnerUserId=##User:int##) UNION (select CreationDate, null, text, 3 from comments where UserId=##User:int##)

fork query

created jun 22 11 Wladimir.Palant