A subroutine available to applications accessing a relational database system.
I want to be able create stored procedures using phpMyAdmin and later on use it through php. But I dont …
php stored-procedures mysql phpmyadminHow can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc …
oracle stored-procedures oracle10g sqlplusI've been working on this for about a day and a half now, and searched numberous blogs and help articles …
sql stored-procedures sql-server-2008-r2 server-errorI want to do this: create procedure A as lock table a -- do some stuff unrelated to a to …
sql sql-server tsql stored-procedures lockingCan I SELECT multiple columns into multiple variables within the same select query in MySQL? For example: DECLARE iId INT(20); …
sql mysql stored-procedures sql-functionI need to pass an array of "id's" to a stored procedure, to delete all rows from the table EXCEPT …
sql sql-server-2005 stored-proceduresHow do you view a stored procedure/function? Say I have an old function without the original definition - I …
postgresql stored-proceduresI need to pass an array of strings as parameter to a MySQL stored routine. The array could be long …
mysql arrays stored-procedures parameter-passingThis works, but i would like to remove the redundancy. Is there a way to merge the update with a …
sql sql-server stored-procedures sql-updateI have a view like this: CREATE VIEW MyView AS SELECT Column FROM Table WHERE Value = 2; I'd like to make …
mysql stored-procedures view parameters