how to execute stored procedure in a function using sql server 2000
-
hi iam using sql server 2000 i want to execute stored procedure in a function and the same function i want to call in view. can you give example which helps me
-
hi iam using sql server 2000 i want to execute stored procedure in a function and the same function i want to call in view. can you give example which helps me
developerit wrote:
i want to execute stored procedure in a function
This is not possible by design, but you can convert the stored procedure in a function and then call it from another function or stored procedure.
developerit wrote:
and the same function i want to call in view.
Not at all possible, View is a mare logical representation of a select statement over tables/ other views. An in line table-valued function can perform as a parametrized view and you can call that in other functions/ stored procedures.
WJFK (Write Just for Kicks)