See your old comments (up to 500) and how many upvotes they have
Q&A for professional and enthusiast programmers
-- Retrieve Your Comments -- See your old comments (up to 500) and how many upvotes they have DECLARE @UserId int = ##UserId## SELECT top 500 Score AS [Up Votes], PostID AS [Post Link] FROM Comments WHERE UserId = @UserId ORDER BY Score DESC