I am looking for a way to get around the lack of a %ROWTYPE in sql server. This seems like a very integral part of any DBMS and Orcale has it. Is there a work around that would be useful without declaring hundreds of variables?