Quotation mark (‘) were used as opening and closing in Software’s query
Happened when Company Name exist quotation marks like (ALI’s BAKERS SHOP)
1. Connect to Database use Microsoft SQL Server Management Studio,
Please refer How to Connect to Database use Microsoft SQL Server Management Studio
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
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