Is there really any difference between these two queries?
SELECT TOP 1000 [COL_1], [COL_2], [...], [COL_n] FROM [database].[schema].[table]
SELECT TOP 1000 * FROM [database].[schema].[table]
Obviously, I will create future problems if I write code like that, but if I really need to see all the columns in my ad-hoc SSMS query window, does it matter? I tried comparing query plans, but saw no differences between the two.
N's match since
SELECT 1 vs
SELECT 1000 was not the point of this question. Also, the suggested post briefly mentions using
I only use it with ad-hoc scrap queries, typically when learning the schema of an object
But that question is focused on enduring code. My question's scope is restricted to ad-hoc statements that will not outlive the current SSMS session.