• Gary Varga (8/5/2014)


    Miles Neale (8/5/2014)


    ...

    Some may feel that there is additional work to build a stored procedure and the code to execute it, but the mitigated risk and flexibility is well worth it.

    ...more effort to debug embedded SQL statements. It is an unnatural for them to exist. No real chance for tool support.

    Gaz - I agree. But some still feel that if you have to interupt the flow of their code and logic to go to another tool and language that is is too much. It is easier for them for some reason to do it all in one place. I do not hold that view, nor will I defend it. But I have heard them speak of this approach as if they are right.

    As to it being unnatural for embedded SQL Statements to exist, it is not but I wish it was.

    M.

    Not all gray hairs are Dinosaurs!