sqlserver : Taking script along with data for a table

create table script along with data:

right click on db

tasks->generate script

select tables

selected advanced button

under general category

check for types of data to scriptTable Script with Data

it has 3 options
1. data only
2. schema only(by default)
3. schema and data

choose 3rd option to get table script along with
data .

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: