My questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

All my questions on the site

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

-- My questions
-- All my questions on the site 

DECLARE @UserId int = ##UserId##

SELECT 
    q.Id AS [Post Link], CASE WHEN q.AcceptedAnswerId IS NOT NULL THEN 'Accepted' END AS Accepted, q.Score, q.body
FROM
    Posts q
WHERE
    q.OwnerUserId = @UserId
  AND
    q.PostTypeId = 1
ORDER BY
    q.Score DESC, q.CreationDate DESC

Enter Parameters

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