I am writing a migration script where I replaced html encoded values by original values like & will get replaced by &. So my SQL query has & letter but when I execute this query it give me popup for every & to replace that character which is as shown below
After clicking on OK its giving anexpecetd result but actually this popup should not come for every &. What should have to do to avoid this popup?
Advertisement
Answer
At the top of your script, add:
set define off;
