Is 'Select Top 1000 Rows' functionality still available in SSMS 17.4?

Question

Is 'Select Top 1000 Rows' functionality still available in SSMS 17.4?

polkadot

Newbie

Points: 0
More actions
January 24, 2018 at 2:08 pm

#332849

My question is about a specific functionality in Microsoft's release of SQL Server client: SSMS 17.4? Is it still possible to R-click on a table and choose "Select Top 1000 Rows'?
--Quote me

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply

Phil Parkin Newbie Points: 0 More actions · Answer 1

polkadot - Wednesday, January 24, 2018 2:08 PM
My question is about a specific functionality in Microsoft's release of SQL Server client: SSMS 17.4? Is it still possible to R-click on a table and choose "Select Top 1000 Rows'?

Yes.

polkadot Newbie Points: 0 More actions · Answer 2

It is still a working functionality ie. it returns top 1000 rows? Sorry, I ask. I am facing an tech support group that will not fix this broken functionality in SQL Server 2017 SSMS on a virtual computer that I am unable to troubleshoot based on claim that SSMS 17.4 doesn't even include this functionality 'so it must be a bug' and is a bad practice.

If the SSMS install were on my own laptop I would repair .net framework as a start (based on forums I have read for this issue).

I use top 1000 a lot in dev environment.

--Quote me

Phil Parkin Newbie Points: 0 More actions · Answer 3

polkadot - Wednesday, January 24, 2018 2:16 PM
It is still a working functionality ie. it returns top 1000 rows? Sorry, I ask. I am facing an tech support group that will not fix this broken functionality in SQL Server 2017 SSMS on a virtual computer that I am unable to troubleshoot based on claim that SSMS 17.4 doesn't even include this functionality 'so it must be a bug' and is a bad practice.
If the SSMS install were on my own laptop I would repair .net framework as a start (based on forums I have read for this issue).
I use top 1000 a lot in dev environment.

Sure. It opens a new tab in SSMS, pastes the SELECT TOP (1000) ... query in and executes it, returning the correct number of rows. Appears to be working as expected.

Lynn Pettis Newbie Points: 0 More actions · Answer 4

Just an FYI, I tried it and it works for me as well.

Gail Shaw Newbie Points: 0 More actions · Answer 5

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass