Ars Technica

Simple question (maybe?): Why use EXEC on a SQL stored procedure call?

Hi Everyone,<BR><BR>I have (I hope) a simple question: why use EXEC when calling a stored procedure (Microsoft SQL 2005) from a SQL query window?<BR><BR>I can do this:<BR> sp_LinkedServers<BR><BR>or I ...
Houston Chronicle

How to Change an Execute SQL Task in SSIS

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to store ...
Linux Journal

MySQL 5 Stored Procedures: Relic or Revolution?

Stored procedures (or stored routines, to use the official MySQL terminology) are programs that are both stored and executed within the database server. Stored procedures have been features in ...
Ars Technica

SQL Help: Stored Procedures and the EXEC command

First, a little background. We haven't moved to ASP.NET yet, so I'm still using GetRows() to retrieve recordsets. We have search pages that bring back a certain number of records per page. Right now, ...
Houston Chronicle

How to Call a Stored Procedure From PHP in MySQL

Stored procedures provide PHP programmers with pre-programmed database applications that retrieve and edit MySQL records. Stored procedures let you send parameters to the database program, so you can ...
InfoWorld

MySQL adding stored procedures to database

Looking to bolster the enterprise-readiness of its open source database, MySQL on Monday will preview an update to its platform that adds stored procedures and server side cursor capabilities. Version ...