Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.
What is the MySQL command to view the definition of a stored procedure or function, similar to sp_helptext in …
mysql stored-procedures stored-functionscan anybody explain what is the main difference between functions and procedures in Oracle? Why must I use procedures if …
oracle stored-procedures plsql oracle11g stored-functionsIf I call a function several time then will it execute every time or just execute once and the value …
mysql stored-functionsVersion: SQLServer 8 I would like to view the contents of a stored function in sqlserver, i.e. what exactly the …
sql-server stored-functionsSQL Server 2005 has great sys.XXX views on the system catalog which I use frequently. What stumbles me is this: …
sql sql-server sql-server-2005 stored-functionsOur database has a function to generate an order number. It reads a value from a Settings table, increments it, …
mysql stored-functionscreate or replace function ar_knyga_egzistuoja( id number ) return number is kiekis number; begin select count(*) into kiekis from …
c# oracle stored-functionsI am looking for a stored procedure code that will open a text file, read in several thousand lines, and …
sql sql-server stored-procedures stored-functionsEverywhere I look it seems MySQL stored procedures can do transactions. Yet when I declare my stored function create function …
mysql stored-procedures stored-functionsI have just started to create a stored function this is my first time so I am having a few …
sql mysql stored-functions