MS SQL Server New Users - Scripting table

Author

Scripting table

Vincent

2005-05-31, 9:23 am

Does any body know if there is a way of scripting table with the contents?

Hari Prasad

2005-05-31, 8:24 pm

Hi,

See the below site to script the table data:- There are many scripts to
generate the data script.

http://vyaskn.tripod.com/code.htm

Thanks
hari
SQL Server MVP

"Vincent" <vincent.kaszta@lmint.com> wrote in message
news:%23gZF2DeZFHA.3732@TK2MSFTNGP10.phx.gbl...
> Does any body know if there is a way of scripting table with the contents?
>
>

Hari Prasad

2005-05-31, 8:24 pm

To add on my previous reply.

The exact link is:-

http://vyaskn.tripod.com/code.htm#inserts

And for DDL's you could use Enterprise manager -- Select database-- Right
click and Generate SQL Script and select the table you need to generate the
DDL.

Thanks
Hari
SQL Server MVP

"Vincent" <vincent.kaszta@lmint.com> wrote in message
news:%23gZF2DeZFHA.3732@TK2MSFTNGP10.phx.gbl...
> Does any body know if there is a way of scripting table with the contents?
>
>

Sponsored Links