Can someone explain to me why one is better than another?
and
Can someone explain to me why one would be used instead of the other?
what are the benefits of each?
I understand how to use both, but i am not sure why a SP is better than a direct SQL access. Both require a server transfer and communication. It seems to me that a SP is best when accessing multiple tables....
The SP may be more secure?
...
Go to the complete details ...