chelandrew
IS-IT--Management
SqlServer 2000. Is there a method to declare a variable of the name and datatype of each column in a cursor, like %rowtype or %type in Oracle? Can table variables be mapped automatically to cursors?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Do SPs have anything like Oracle's rowtype for cursors?
- Thread starter chelandrew
- Start date
- Status
According to SQL Server Books Online
Transact-SQL does not support the %TYPE and %ROWTYPE variable data type definitions. A Transact-SQL variable cannot be initialized in the DECLARE statement. The NOT NULL and CONSTANT keywords cannot be used.
Like Oracle LONG and LONG RAW data types, text and image data types cannot be used for variable declarations. Additionally, the PL/SQL style record and table definitions are not supported.
Chalk up another point for Oracle.
Transact-SQL does not support the %TYPE and %ROWTYPE variable data type definitions. A Transact-SQL variable cannot be initialized in the DECLARE statement. The NOT NULL and CONSTANT keywords cannot be used.
Like Oracle LONG and LONG RAW data types, text and image data types cannot be used for variable declarations. Additionally, the PL/SQL style record and table definitions are not supported.
Chalk up another point for Oracle.
- Status
Similar threads
- Locked
- Question
- Question