thanksThere's plenty of pro's as well as con's to procedures.
One of which is how dynamic you can have these sql statements. However, since it's not so dynamic, the chances of sql injection is far less of an issue.
Furthermore, procedures compile an execution path, and will usually execute much faster. If you have multiple requests you need to make, your procedure can consolidate many calls into one, reducing round trips.
Can you be a bit more specific? This question seems beaten to death, and I'd really suggest just going through the threads or using the search feature.|||See this...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/storedprocsnetdev2.asp
No comments:
Post a Comment