vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Oracle and SQL Server both have them. Data types that are tables that can be passed into a stored procedure via parameters or returned. Most people might think of it as convenient composite type that allows the communicating more complex data between procedures and applications. The only way to get around this limitation today is to design around it. Visibility limitations between procedure scopes limit the ability to share working tables, unless the data within them is indexed such that one process' data can be kept separate from another using the same procedures. Isn't this an old idea? It's part of SQL Server 2000, and Oracle's has been around since 1992. Makes me wonder what Sybase is spending their R&D money on. -- Visit <http://blogs.instreamco.com/anything.php> to read my rants on technology and the finance industry. Visit <http://tggagne.blogspot.com/> for politics, society and culture. |