Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSMS Quick ways to get data

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.
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>> 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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Avatar of Murray Brown

ASKER

Thanks for the advice