all groups > sql server programming > july 2005 >
You're in the

sql server programming

group:

Insert scripts


Insert scripts J-T
7/23/2005 2:08:38 PM
sql server programming:
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

Re: Insert scripts Tibor Karaszi
7/23/2005 11:43:06 PM
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/


[quoted text, click to view]
Re: Insert scripts Narayana Vyas Kondreddi
7/24/2005 1:12:38 AM
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/


[quoted text, click to view]

RE: Insert scripts Thomas
8/24/2005 5:23:02 AM
Try www.sqlscripter.com
Its free

[quoted text, click to view]
AddThis Social Bookmark Button