Q&A for meta-discussion of the Stack Exchange family of Q&A websites
DECLARE @UserId int = ##UserId## SELECT TOP 100 Score, LEFT(Text, 100), PostId as [Post Link] FROM Comments WHERE UserId = @UserId ORDER BY Score DESC, PostId DESC