Re: Pass Table as a parameter to a function



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.

Or you have a bad design which you are not showing us. That is what Ia
m beting.

I have to access a temporary table created in an SP in a function <<

No, you do not. You just don't know how to write declarative, non-
procedural code so you are mimicking a scratch tape with a table that
appears out nowhere in your data model as if you were still using a
magnetic tape file system instead of an RDBMS.

.



Relevant Pages

  • Re: Pass Table as a parameter to a function
    ... Please read a book, any book, on data modeling, and RDBMS. ... magnetic tape file system instead of an RDBMS. ...
    (comp.databases.ms-sqlserver)
  • Re: Pass Table as a parameter to a function
    ... 'Please read a book, any book, on data modeling, and RDBMS. ... But the super function, reusable functions, is precisely what modern ... with the mickey mouse idea of passing a table 'memory' variable ...
    (comp.databases.ms-sqlserver)
  • Re: Reference temporary table twice
    ... RDBMS would not use Employees because tables ... What you are doing is writing a 1950's magnetic tape file that ... PHYSICALLY moves data from PHYSICAL location to PHYSICAL location. ... You will get Kludges here for putting the totally un-related data ...
    (microsoft.public.sqlserver.programming)
  • Re: Modeling the TV Guide
    ... Rich R wrote: ... > <Since you're teaching, why not model something a bit more logical and ... >>more suited to a RDBMS? ... > The reason why is that most examples of data modeling are cliches: ...
    (microsoft.public.sqlserver.programming)
  • Re: Modeling the TV Guide
    ... > more suited to a RDBMS? ... The reason why is that most examples of data modeling are cliches: ...
    (microsoft.public.sqlserver.programming)