• No need for anything fancy.

    This should work:

    update Table2

    set Domain = isnull((select Domain from Table1 t1 where t1.ServerName = Table2.ServerName), 'Unknown')