SQL Server Script to Create INSERT Statements - Deep in the Code
Though you can generate INSERT statements using SQL Server Management Services if the Generate Scripts functionality is enabled, this script may help in cases when it is not. This script may not work in every single case, as there are data types not accounted for here.