Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 18:10:12
|
dag writes "I have a stored procedure (foo), that returns a value, not in the RETURN
clause or OUTPUT parameter, but in a SELECT statement.
For example just calling the sp:
exec foo 13 => 42
and everything is fine.
Q: Can I use this stored procedure inside a view, so that I could
essentially have a calculated column?
Am using SQL Server 7.00.623 (MSDE). on NT4SP6
Other DBMSs allow this, like PostgreSQL w something called
CREATE FUNCTION...
Thanks,
/Dag" |
|
|
|
|
|
Can a stored procedure be used in a view?