Insert scripts

I'd like to generate a script which contains insert commands (with full name
of columns and their values) out of the data in one of my tables something
like this:
Insert TBTest(Col1,Col2) Values ('1',2)
I have seen couple of tools which create insert into select .... sort of
command which is not the one that I want.
Thankshttp://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"J-T" <J-T@.nospam.com> wrote in message news:eRp9yq8jFHA.3164@.TK2MSFTNGP15.phx.gbl...[color
=darkred]
> I'd like to generate a script which contains insert commands (with full na
me
> of columns and their values) out of the data in one of my tables something
> like this:
> Insert TBTest(Col1,Col2) Values ('1',2)
> I have seen couple of tools which create insert into select .... sort of
> command which is not the one that I want.
> Thanks
>[/color]|||Try my stored procedure:
http://vyaskn.tripod.com/code.htm#inserts
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"J-T" <J-T@.nospam.com> wrote in message
news:eRp9yq8jFHA.3164@.TK2MSFTNGP15.phx.gbl...
> I'd like to generate a script which contains insert commands (with full
> name
> of columns and their values) out of the data in one of my tables something
> like this:
> Insert TBTest(Col1,Col2) Values ('1',2)
> I have seen couple of tools which create insert into select .... sort of
> command which is not the one that I want.
> Thanks
>|||Try www.sqlscripter.com
Its free
"J-T" wrote:

> I'd like to generate a script which contains insert commands (with full na
me
> of columns and their values) out of the data in one of my tables something
> like this:
> Insert TBTest(Col1,Col2) Values ('1',2)
> I have seen couple of tools which create insert into select .... sort of
> command which is not the one that I want.
> Thanks
>
>