Jojo what protects against SQL injection is good programing not the use of SP, you should always use parameters that is what will protect you from sql injection.


>>You're taking it too personally. As are most here.
>>
>>I'm just looking for somebody to engage Walter's points so I can try to learn something.
>>
>>OK, here is one reason to use SP:
>>
>>1) Critical transactions- If you have a scenario where multi-table writes need to be transacted without fail to avoid disastrous consequences, forcing use of a SP is a reliable way to ensure compliance. Example- banking transactions, controlled substance stockkeeping.
>>
>>Do you agree?
>
>Sorry to jump in, I agree and in addition to what you say, using SP protect SQL injection attack. :)