query passed by value from a udf?

> No, the instance itself - the variable that corresponds to the > function itself - need not stay in memory. It will go out of scope > right after it runs, and will be eligible for garbage collection. But > the query that was created by that function will remain in memory > until all references to that query no longer exist. But we're talking about a single request so if there is no garbage collection during a requests lifetime, being eligible or not makes no difference. Be that as it may, you're saying that the fact that a reference to the query is still in use, the query 'jumps' out of the UDF's local scope to live on in the requests memory. > thing to understand here is the difference between the stack and the > heap. References exist on the stack; the objects being referenced > exist in the heap. Can you expand a bit on what you're saying here? Thanks