Copy and Past — To update your table data in SSMS (SQL Server 2008/+)Posted: February 23, 2012
You can import your data to your local or remote database for development to refresh your table data.
We have done this through SQL Server Import/Export wizard for many years. Here comes an easy way now. You can copy your data from different sources with the same structure to past them to your data table to refresh the content.
In your table, you choose the edit mode and highlight a new row and paste the content and the data table will be updated with the new data.
You can copy the dataset from query resultset, excel spreedsheet or another same structure table.
You can copy the identity column with the dataset but it will be recreated with new values.
Hope this tip will help.