(Optimum) Upgrade database prompted Incorrect syntax near 'S'. Unclosed quotation mark after the character string ''.’ : QNE Software Sdn. Bhd.

(Optimum) Upgrade database prompted Incorrect syntax near 'S'. Unclosed quotation mark after the character string ''.’ Print

Created by: Cheng Kah Poh

Modified on: Wed, 11 Nov, 2020 at 9:07 AM

Solution:

Root Cause:

Quotation mark (‘) were used as opening and closing in Software’s query

Happened when Company Name exist quotation marks like (ALI’s BAKERS SHOP)

Solution:

1. Connect to Database use Microsoft SQL Server Management Studio,

adn

2. Start a New Query

3. Copy and Paste the following SQL Script into the New Query

UPDATE CompanyProfile

SET BranchCode = '0000'

WHERE CompanyName = 'ALI''s BAKERS SHOP'

--- If Company Name = ALI’s BAKERS SHOP

--- then change it to ALI'’s BAKERS SHOP

4. Execute the Query

5. You may continue to upgrade your database

Cheng is the author of this solution article.

Did you find it helpful? Yes No

(Optimum) Upgrade database prompted Incorrect syntax near 'S'. Unclosed quotation mark after the character string ''.’ Print