Is 'Select Top 1000 Rows' functionality still available in SSMS 17.4?
-
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
- polkadot - Wednesday, January 24, 2018 2:08 PM
Yes.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
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
- polkadot - Wednesday, January 24, 2018 2:16 PM
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Just an FYI, I tried it and it works for me as well.
-
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply