Copy and Past — To update your table data in SSMS (SQL Server 2008/+)

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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s