Hi All, I need stored procedures which should return insert script for particular rows in a table. Ex: Assume, my employee table contains 100 rows.if i pass table name, employeeid the Sp should return insert script for this rows alone. Thanks in Advance.

May be you are looking for this code...

http://vyaskn.tripod.com/code/generate_inserts.txt