>>Your syntax is correct. Do you get errors, if yes, what are they? I suspect you may have triggers on the table that changes the behavior...
>
>The name MyTable2 was underlined with squiggly red line. The table does have triggers. Is there a way to exclude the triggers?

You can disable the trigger, but you didn't tell what the errors were. Post the error message.

Also, try refreshing the local intellisense cache so you would not get red squiggly line.