Notepad++ is nice - you can edit, with syntax highlighting - it has plugins for auto-formatting too.
You can edit in the application, and refresh in the SQL browser (I think TOAD does this, and the other one I usually use, but can;t remember the name of)
It has a portable version that can be run from a standalone folder, so doesn't need installing.
[Edit]
IIRC, it also has a plugin for connectors, but I've never felt the need to use them.
Notepad++ is nice - you can edit, with syntax highlighting - it has plugins for auto-formatting too.
You can edit in the application, and refresh in the SQL browser (I think TOAD does this, and the other one I usually use, but can;t remember the name of)
It has a portable version that can be run from a standalone folder, so doesn't need installing.
[Edit]
IIRC, it also has a plugin for connectors, but I've never felt the need to use them.