Stored procedures, as everyone mentioned, have huge advantages, and it is recommended that you use them whenever possible. However, a disadvantage that few speak about, is how to keep them in version control.
Reuben http://whatiseeinit.blogspot.com/ On 25 April 2012 15:25, Stephen Russell <srussell...@gmail.com> wrote: > On Tue, Apr 24, 2012 at 2:49 PM, carlos augusto adames jimenez > <augustoada...@gmail.com> wrote: > > Hi, i would like you to help me up to know the difference between Stored > > Procedures and Sql Sentences. When to use one or another. > > > > Hope you can help me clarify this. For me as a programer which is more > > recommended to use? > ---------------- > > Stored Procedures. > > 1. Reusable by others on a project > 2. Tuneable by dba if found to have a poor inndex in support > 3. Passing params instead of straight text prime for SQL Injection. > > > Do you need more? > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to dotnetdevelopment@googlegroups.com > To unsubscribe from this group, send email to > dotnetdevelopment+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
