Scripting table data in SQL Server 2008R2 and above

As you many of the SQL programmers may already know. In SQL Server, it is possible to prepare and save scripts for database or table schemas. In some cases you may also need to script your data stored in the tables. This is a very simple task but it is possible to miss or forget where it is located and how this was achieved.

Read the rest of this entry »

Advertisements