My Most Popular Comments

6

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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

Enter Parameters

Options:
Switch sites:
Hold tight while we fetch your results
{"cc_re__cc_re__cc_by_sa_4_0": ["t</a>\r\n                <a href=\"https://data.stackexchange.com\">data</a>\r\n                <a href=\"https://stackexchange.com/legal\">legal</a>\r\n                <strong><a href=\"http://meta.stackexchange.com/contact\">contact us</a></strong>\r\n                <strong><a href=\"http://meta.stackexchange.com\">feedback</a></strong>\r\n            </div>\r\n            <div id=\"copyright\">\r\n                site design / logo &copy; 2020 Stack Exchange Inc; \r\n                user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/4.0/\" rel=\"license\">cc by-sa 4.0</a>\r\n                with <a href=\"https://stackoverflow.blog/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"revision\">rev 2020.4.23.70</div>\r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">\r\n            Data Explorer works best with JavaScript enabled</div>\r\n    </noscript>\r\n    <script>\r\n(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){\r\n(i[r].q=i[r].q||[]).p"], "copyright__copyright__copyright": ["ogin or register to vote for this query.\n\n(click on this box to dismiss)\n\nQ&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation\n\nDECLARE @UserId int = ##UserId##\n\nSELECT \nTOP 100\n    Score,\n    LEFT(Text, 100),\n    PostId as [Post Link]\nFROM \n    Comments\nWHERE \n    UserId = @UserId\nORDER BY \n    Score DESC,\n    PostId DESC\n\nEnter Parameters\n\nOptions:\nSwitch sites:\nHold tight while we fetch your results"]}