Insert scripts

23 Jul 2005 9:08 PM

J-T

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

23 Jul 2005 9:43 PM

Tibor Karaszi

http://www.karaszi.com/SQLServer/info_generate_script.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"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
>
>

24 Jul 2005 12:12 AM

Narayana Vyas Kondreddi

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/

Show quote

"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
>
>

24 Aug 2005 12:23 PM

Thomas

Try www.sqlscripter.com
Its free

Show quote

"J-T" wrote:

> 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
>
>
>