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

- URL: https://dynamicaccounting.net/quick-tip-copying-small-amounts-of-data-in-sql-server-quickly-developing-for-dynamics-gp/
- Date: 2012-02-14
- Topics: Tips & Hidden Features, SQL & Data, Install, Upgrade & Admin
- Type: link to an external article
- Source: https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/02/12/quick-tip-copying-small-amounts-of-data-in-sql-server-quickly/

David Musgrave reminds us of a technique for [Copying small amounts of data in SQL Server quickly](https://blogs.msdn.microsoft.com/developingfordynamicsgp/2012/02/12/quick-tip-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.