Declaring Local Variables

Use DECLARE consistently.  Both of these styles are acceptable:

DECLARE
    @error    int,
    @list     varchar(512),
    @rowcount int,
    @spName   sysname

DECLARE @error    int
DECLARE @list     varchar(512)
DECLARE @rowcount int
DECLARE @spName   sysname

Lining up the datatypes is not required. Neither is keeping all the variables in alphabetical order. Unless you're anal like I am. I believe it helps readability.

This style is not acceptable:

DECLARE @error int, @list varchar(512), @rowcount int, @spName sysname

When modifying existing code, use the style that is already there.