Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Nick Greene,
SQL server management studio interface provides the ability to create insert scripts for tables, but I needed a way to automate this insert script building process. I ended up writing my own stored procedure to allow me to do this. It accepts 5 parameters:
I have not built this to support ALL data types, but it will support, what I consider to be, the most common data types. If you attempt to execute it on a table that contains an unsupported datatype it will error out and inform you it does not support the datatype. I use it primarily in SQL 2008, but it should work in 2005. I have not tested it in 2012, but I would expect it to work.
I have also posted this on my blog at sqlprosperity.com
If you were putting together a security awareness training program for
developers, what aspects of ...
Foreign Language Support.
I would like to insert from the clipboard text with line breaks in a "varchar" column.