CapsuleCorpJX
IS-IT--Management
Are Stored Procedures really better than SQL/KSH Scripts (using the BTEQ function)?
I've found some sites that say Stored Procedures aren't even precompiled.
That and since I have to pass in parameters for database names to a stored procedure, I have to use dynamic sql to perform dynamic selects. But is that even less efficient then scripts?
Is there any real advantage to use Stored Procedures over Scripts?
I've found some sites that say Stored Procedures aren't even precompiled.
That and since I have to pass in parameters for database names to a stored procedure, I have to use dynamic sql to perform dynamic selects. But is that even less efficient then scripts?
Is there any real advantage to use Stored Procedures over Scripts?