NOTE: This script will give error if you have MONEY data type field in table.
Create this procedure and use following command to execute this:
Exec usp_Generate_Inserts 'Customers' --Customers is the table name
Go
--Output is something like this for all the rows
INSERT INTO [dbo].[Customers](CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax) VALUES('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin',NULL,'12209','Germany','030-0074321','030-0076545')
