Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DonFelipe
Starting Member
2 Posts |
 Posted - 2008-10-21 : 09:01:35
|
| I need to translate a script from Oracle to SQL Server 2005. There I don't know what to do with the following code:CREATE TYPE ReportEntry IS RECORD ( id INTEGER , caption VARCHAR2(50));TYPE ReportEntry_TABLE IS TABLE OF ReportEntry;I've seen a resolution for it for newer Versions but not for the 05.Many thanks in advance! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-21 : 09:53:00
|
| Seems like what you want is thishttp://doc.ddart.net/mssql/sql70/sp_addp_16.htm |
 |
|
|
DonFelipe
Starting Member
2 Posts |
Posted - 2008-10-21 : 10:10:27
|
| This seems to be only for one value. What I am looking for is to store two values(id and caption) in one variable, as I understood the script... |
|
|
|
|
|
|
Translating TYPE from Oracle to SQL Server