Link to home
Start Free TrialLog in
Avatar of enrique_aeo
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
Avatar of Coralie Crumrine
Coralie Crumrine
Flag of United States of America image

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?
Avatar of enrique_aeo
enrique_aeo

ASKER

sorry, forget the part I do not understand

"Its primary purpose is to build intermediate results"
ASKER CERTIFIED SOLUTION
Avatar of JohnMaddenTX
JohnMaddenTX

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can do the instance with the adventure works database