>BTW, what's all this '@' stuff about, anyway? What does an '@' do? I'm looking at the docs for @local_variable, but it's going way over my head...
>

The @ is just a requirement for naming your local vars in T-sql. I suppose it distinguishes variables from field and table names.

DECLARE @state char(2)
SET @state = 'UT'