Post reply

Quotations

  • May 26, 2010 at 3:30 am

    #140515

    I have written a stored procedure that updates data, it runs ok until it reaches the name Milly's.

    I know the problem is with the quotation but I am not sure how to correct it.

    the fields are ORG= '''+@FIELD1+''',

    Field 1 equals Milly's

  • May 26, 2010 at 3:38 am

    #1172558

    Surely this is a T-SQL question, not SSIS?

  • May 26, 2010 at 3:48 am

    #1172564

    Best answer, dont use dynamic SQL.

    Doing a quote twice will imply to sqlserver that you need the value of quote.

    Consider this statement

    select ''''

    You will have to modify the value held in the value , replace is probably the best option.


    Clear Sky SQL
    My Blog[/url]

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

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