t-sql

SQL SERVER %26ndash; 2008 %26ndash; Copy Database With Data %26ndash; Generate t-sql For Inserting Data From One Table to Another Table
Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER %26ndash; Insert Data From One Table to Another Table %26ndash; INSERT INTO SELECT %26ndash; SELECT INTO TABLE . Today, we will go over a similar question regarding how to generate script for data from database as well as table. SQL Server 2008 has simplified everything. Let us take a look at an example where we will generate script database.