Here is a little more information on working with recordsets:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrec.asp

Your datatype should be datetime instead of date.

Sample:

 DECLARE @deficit_year datetime

A note on the trigger above:

It assumes that both ColA and ColB contains a value.  If either ColA or ColB is Null, ColC will also equal Null.

If these are numeric fields...

In a perfect world a database would be used to strictly store data... as we all know we are in a far from perfect world, and databases are becoming more...

If you have three databases in suspect mode using sp_resetstatus is probably not going to work.  sp_resetstatus is going to tell SQL that the data is good, however, the next...