Create Insert Script in SQL Server 2008..

by 10:30 PM 0 comments
If we want to generate Insert Script with data values, it was not possible before SQL Server 2008.
Now SQL Server 2008 support insert script with data also.

Here are steps for it

1. Right click on database, select task -> generate scripts

2. Follow the wizard , select DATABASE

3.In the choose script options, select Table View Options -> script data

Follow remaining options.

The script generated by wizard will have insert script with data.

ravi tuwar

Developer

Cras justo odio, dapibus ac facilisis in, egestas eget quam. Curabitur blandit tempus porttitor. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor.

0 comments:

Post a Comment