Top "Stored-functions" questions

Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.

Testing performance of Scalar vs Table-valued functions in sql server

OK so I have read a whole bunch of articles suggesting table-value functions and cross apply give better performance than …

sql sql-server-2005 stored-functions
Optimizing a stored function call in SELECT and WHERE clauses

I have an SQL query with the following structure: SELECT *, storedfunc(param, table.field) as f FROM table WHERE storedfunc(…

mysql stored-functions
Stored function with temporary table in postgresql

Im new to writing stored functions in postgresql and in general . I'm trying to write onw with an input parameter …

postgresql stored-procedures stored-functions
Temporary Table in Stored Functions?

I'm writing a function that I need to use either a TABLE variable for (I hear they don't exist in …

mysql stored-functions
Call stored MySQL function

I've created a stored function verifierQteDemandee in my database which has an integer parameter numBonIn, which returns a boolean value. …

java mysql stored-functions
How to use variables in "EXECUTE format()" in plpgsql

I want to update a column in table stats with the specific column being a parameter, then return the updated …

sql postgresql plpgsql dynamic-sql stored-functions
MySQL Function: Selecting and returning column

I have a table Processes, which consists of an ID (unsigned int, auto_increment) and Name (varchar, unique). Selecting the …

mysql sql stored-functions
Using variables as OFFSET in SELECT statments inside mysql's stored functions

I'm quite new to subject of writting stored function for mySQL database, hence i'm not sure if what i'm trying …

mysql stored-functions
Search 'grep-alike' through PostgreSql functions

When refactoring PostgreSql functions (and more specific: while searching for 'unused' functions) it would be handy to have a function …

postgresql refactoring stored-functions
Usage of stored functions in entity framework

I have an old Oracle DB which I'm trying to use within EntityFramework 4.1 application. I've read about the big limitation …

c# .net oracle entity-framework stored-functions