Script Table Data to Insert Statements

This script will create a series of insert statements for a given table. It does not support every single data type in every way and has some limitations. If you add any enhancements, please send them to me at bbyrd@intellithought.com so I can update it here. Update (28 Feb 2005): Added support/Fixed bug with smalldatetime type. Contributed by Bob Wiechman. Thanks Bob! Update (13 Dec 2005): Corrected support of uniqueidentifiers, added automatic identity detection, added filtering of output, added more detail in debug mode. Contributed by Richard Lesh. Thanks Richard!