Generic Sql Table Data Insert Script

woah!!

I have my own blog and this is my first posting. hurray.... I have been shying away from doing this for a long time now... finally pulled all my energies to start blogging tech stuff that I learn ...

There is so much that I learn and so much I forget all the time.... It is getting really tough to keep track of all that I have learned.... I hope I can keep up with posting useful stuff that I learn.

enough of my preamble now... cutting the chase and getting to my post...

How many time must I have thought " I wish I had a script that I would run with the table name as an argument and get insert statements for all the data in a Sql Server 2000/2005 table." Thanks to Narayana Vyas Kondreddi, I have got a script [1] that does exactly what I want. This is a cool utility that is very handy.

To generate INSERT statements for table 'titles':
EXEC sp_generate_inserts 'titles'


References:
1. http://vyaskn.tripod.com/code.htm#tagit