Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
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