In Oracle PL/SQL scripts, you can declare a variables using the syntax tablename%rowtype for its type. This will make that variable have the same "type" as a row of that table
(i.e. a it will be a structure with the same field names and types).
This is a convenient way to transfer data between database tables and PL/SQL.
I am looking at doing the same thing (Data Type) in Microsoft SQL Server 2008. Is there an equivalent feature?