RE: Do you know where i can find the famous stored procedure

SSC Guru

Points: 323504

February 26, 2015 at 2:11 pm

mw112009 (2/26/2015)
Tried that web page. it is not there any more...
You can share yours if you like.
The only good thing is he had written in in such a way that it changes the values to OCTAL. This way he did not have to worry about the values that had single quote characters inside varchar fields.

not sure about octal, but the procedure usp_generate_inserts in this article:

http://www.sqlservercentral.com/articles/T-SQL/66987/

builds hex strings for the values, maybe that's what you remember?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!