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,
Please refer How to Connect to Database use Microsoft SQL Server Management Studio
adn
Please refer How to install Microsoft SQL Management Studio
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article