i read some articles from internet about Stored Procedures,many of them told us that Stored Procedures is not good and it is bad.... i want to stat my new application..and i will not use it if it is bad.. can you tell me if these article true..???/
Good if you know without a doubt: 1) you will never switch databases 2) you will never need to rewrite the procedure.
The problem with them is if you write too many (hundreds) trying to update them later for small changes or new databases can be nearly impossible. In general, I try to avoid them at all costs unless they are absolutely needed (usually when large chunks of the database are required for a calculation such that performing in client-side would not be possible or would require downloading to much data). Even then I try to avoid such problems with de-normalization and caching. [ April 15, 2007: Message edited by: Scott Selikoff ]