enrique_aeo
asked on
Rewriting Stored Procedures as Functions
Hi experts, i am reading about
Rewriting Stored Procedures as Functions
but i do not understand nothing, can you give me an example in code transact sql
Rewriting Stored Procedures as Functions
but i do not understand nothing, can you give me an example in code transact sql
Stored procedures act like a sub and run the command on the sql server. A stored function runs the code and returns a value or multiple values. Do you have a specific stored procedure that you need help with or are you just looking for a conceptual explanation?
ASKER
sorry, forget the part I do not understand
"Its primary purpose is to build intermediate results"
"Its primary purpose is to build intermediate results"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You can do the instance with the adventure works database