How do I escape _ in SQL Server? [duplicate]

Just this should work:

COLUMNNAME NOT LIKE '%[_]xyz%'

You don’t need the ESCAPE here. What you wrote should also work.

If you do want to use ESCAPE you could do this:

columnname NOT LIKE '%\_xyz%' ESCAPE '\';

Documentation on escape characters is here.