If supported, developers are strongly encouraged to use stored procedures. They generally execute faster because they can be compiled and/or optimized by query planning and index selection techniques by the database, they are more easily managed and secured by DBAs through the user and role facilities offered by most databases, and their parameterized interface gives developers an addition level of resiliency against SQL-injection vulnerabilities.
Not every data provider supports the use of stored procedures.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2