We help IT Professionals succeed at work.

SSMS Quick ways to get data

Murray Brown
Murray Brown asked
on
Hi
In SSMS are there quick ways to get data from tables using right clicks, drag and drop and the like?
I have a number of tables of around a hundred thousand records that I need quick access to.
Comment
Watch Question

View Solutions Only

Software Team Lead
Commented:
In SSMS are there quick ways to get data from tables using right clicks, drag and drop and the like?
sorry, the quickest is to use "Select Top xxx rows" option. For the drag and drop feature, you can only do that to populate the object (table, field, etc)'s name but not the data by itself.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
>> In SSMS are there quick ways to get data from tables using right clicks, drag and drop and the like?

As mentioned above, simply Right Click your table and Choose Select Top 1000 Rows(configurable with options)

>> I have a number of tables of around a hundred thousand records that I need quick access to.

Can you clarify more on what kind of quick access you would be performing so that we can suggest better.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
SSMS is a developer interface and not an UI for the lowest skilled user, so asking 'are there quick ways to get data from tables' is not a really valid use of SSMS.  Microsoft has no plans on 'SSMS for the masses'.  Currently those types of activities are Power Query and Power BI.

> I have a number of tables ... that I need quick access to.
Define 'quick access' in a use case as to why you need this and what you use it for, and perhaps we can recommend another solution.
arnold
Distinguished Expert 2019

Commented:
Please clarify, there is a query designer.

What are you trying to do/end up with.

Which SQL version?

If you ow the query, you could use powershell, bcp to export ......

How much data/what are you trying to end up with?
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks for the advice