Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    Unanswered: Replace Apostrophes for Openquery??

    Hi All,

    I have trigger that sends data from one table to another.
    I am using the Openquery statement within the trigger to send the data.

    However when I Insert anything with an apostrophe into the table where the trigger resides it errors saying...

    "Incorrect syntax near" where the apostrophe is and this puts out the number of Quotes in the Openquery Statement.

    I use the Replace function written as REPLACE(@VARIABLE, '''', '''''') to replace One Apostrophe with 2.
    I'm not sure whether I can use this with Openquery or not / or whether the syntax is correct for Replace in conjunction with OpenQuery.

    If someone can give me anysight into this and any code on how to do this would be great.

    Thanks
    Anthony

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    You are posting on multiple forums

    Once again EXEC(), QUOTENAME()

  3. #3
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    QUOTENAME??

    How do I use QUOTENAME() if I want to use a variable that has a value of "O'Reilly" for instance for the following OPENQUERY statement within the trigger



    SET @TSQL = 'INSERT INTO ' +
    'OPENQUERY(AUTHTEST,''Select nar_num, ser_key, alp_key from aunrmast'') ' +
    'VALUES(0, '''', ''' + @VARIABLE + ''', 99)'

    EXEC(@TSQL)

    Thanks for your help on this

    Anthony

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    select QUOTENAME('O''Reilly','''')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •