Posted by steve on 08/12/07 06:04

In the thread:
comp.databases.ms-sqlserver
Jul 25, 6:52 am
'Pass Table as a parameter to a function'
http://tinyurl.com/2j4dvy

Joe Celko makes the following comment on passing a table as a
parameter to a procedure:

>> Is it possible to pass a table as a parameter to a function. <<

'Please read a book, any book, on data modeling, and RDBMS. A table
is an entity or a relationship. That would mean you have a magical,
super function that works on Squids, Automobiles, Britney Spears,
Geographical locations or anything in the whole of creation.'

But the super function, reusable functions, is precisely what modern
database developers should have at their disposable! And you can have
it:

http://beyondsql.blogspot.com/2007/08/dataphor-creating-super-function.html

It's also a chance to contrast the idea of a table as a variable,
'any' table, with the mickey mouse idea of passing a table 'memory'
variable as being implemented in Katami. We are talking apples and
oranges folks :-)

[Back to original message]