Rick Morrison wrote:
> Only rarely is there only one way to do something in MSSQL ;-)
>
> Stored procedures can also be called simply by name, omitting the "EXEC":
>
> EXEC procedure_foo <parms>
> or
> procedure_foo <parms>
True, as long as the call is the first statement in the batch;
otherwise, you need the exec.
>
> and I believe they can also be called from within a subquery:
>
> select * from (procedure_foo)
No, but mssql has the concept of "table-valued user defined function",
so you could have something like
select * from dbo.foo(@var)
-- think of it as a "parameterized view".
I agree that something like the "returns_results" hint might be a good
way to go.
--
Don Dwiggins
Advanced Publishing Technology
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
