Camillia
asked on
Interview question - when to use stored procs
I've been ask this question in two different interviews...
What is the benefit of using stored proc ? another guy asked... when would you use a stored proc over inline sql
My answer:
Stored proc makes an application database agnostic ... application layer is separate from the data
Stored procs are compiled
----
When do we want to use a SP over inline SQL? I didn't answer this one.
---
No matter how much I prepare for an interview... there's always something unexpected thrown at me!
What is the benefit of using stored proc ? another guy asked... when would you use a stored proc over inline sql
My answer:
Stored proc makes an application database agnostic ... application layer is separate from the data
Stored procs are compiled
----
When do we want to use a SP over inline SQL? I didn't answer this one.
---
No matter how much I prepare for an interview... there's always something unexpected thrown at me!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Kyle
ASKER