Quick Tip: Copying small amounts of data in SQL Server quickly – Developing for Dynamics GP

Tips & Hidden Features SQL & Data Install, Upgrade & Admin

Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

David Musgrave reminds us of a technique for Copying small amounts of data in SQL Server quickly. This works really well but David is right. It only works for SMALL amounts of data. Paste too much and you’ll be looking at blank screen for a long time praying that you did this right.

Original article: https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/02/12/quick-tip-copying-small-amounts-of-data-in-sql-server-quickly/