Post reply

QUOTENAME on a Varchar(Max) column

  • November 18, 2011 at 1:53 pm

    #252113

    Hello Everyone

    I am trying to create an insert statement from one table. The table has data in it, and one of the columns has a data type of Varchar(max). I am able to get create an insert statement using the QUOTENAME function for all the columns except for the varchar(max)

    Is there a way that I can create an insert statement with the data using anything else?

    Thank you in advance for all your help

    Andrew SQLDBA

  • November 18, 2011 at 2:38 pm

    #1410213

    Andrew the SSMS Add In from http://www.ssmstoolspack.com/ *** the ability to script data easily from SSMS....

    for a scripted solution , i've used this script from Narayana Vyas Kondreddi a lot, and it's pretty full featured.

    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!

  • November 18, 2011 at 2:51 pm

    #1410215

    Thanks Lowell

    Just as I posted, I thought of something. Just script the objects in the database, and select only that one table, with data. That works perfectly.

    I am always doing that...... Thinking of a way, right after I ask someone.

    But I am always thankful that people like you are out there to lend a hand.

    Hope that you have a nice weekend, and thanks again

    Andrew SQLDBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply