InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 18:30:12 GMT20http://www.sqlservercentral.com/Forums/Topic547323-338-1.aspxIn case you miss is, article [url=http://www.sqlservercentral.com/articles/T-SQL/66987/]Generating Insert Statements[/url] is republished today.Also, there is my own article, [url=http://www.sqlservercentral.com/articles/scripting/64884/]Scripting INSERTs[/url], which is intended to do address a slight different issue - where you want to script individual bits of tables, perhaps subject to conditions on the records - and also you can edit the script more easily if you aren't just looking for a straight copy. It doesn't support some of the more exotic datatypes though.I think both are subject to the provisos about IDENTITY fields etc, although I guess if you can just turn IDENTITY_INSERT on for the table in that particular case.TonyFri, 14 May 2010 02:41:39 GMTTony Websterhttp://www.sqlservercentral.com/Forums/Topic547323-338-1.aspx[quote][b]toprprasad (8/6/2008)[/b][hr]Hi...I need a script which can generate insert statements for all the records in a table. for eg: if a table abc has 2 records, then on executing this script, it should generate 2 insert statements with column names and values.thxraj[/quote]See the method in the link in my signature below.Wed, 06 Aug 2008 08:34:58 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic547323-338-1.aspxI'm lazy, I use ApexSQL Edit.... =)Wed, 06 Aug 2008 08:23:26 GMTAnders Pedersenhttp://www.sqlservercentral.com/Forums/Topic547323-338-1.aspxThat doesnot matter... Ultimately , i need insert statement for each record in the table.Wed, 06 Aug 2008 02:54:51 GMTtoprprasadhttp://www.sqlservercentral.com/Forums/Topic547323-338-1.aspxThere may be the possibilities that table either contains Primary / Identity Field or may not contains any ke, so in that case how do you insert the record ?Wed, 06 Aug 2008 02:42:50 GMTAbhijit Morehttp://www.sqlservercentral.com/Forums/Topic547323-338-1.aspxHi...I need a script which can generate insert statements for all the records in a table. for eg: if a table abc has 2 records, then on executing this script, it should generate 2 insert statements with column names and values.thxrajWed, 06 Aug 2008 02:37:49 GMTtoprprasad