Use stored-functions for questions related to database specific user-defined functions which can perform queries, accept parameters, and return a computed value.
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-functionsI have an SQL query with the following structure: SELECT *, storedfunc(param, table.field) as f FROM table WHERE storedfunc(…
mysql stored-functionsIm new to writing stored functions in postgresql and in general . I'm trying to write onw with an input parameter …
postgresql stored-procedures stored-functionsI'm writing a function that I need to use either a TABLE variable for (I hear they don't exist in …
mysql stored-functionsI've created a stored function verifierQteDemandee in my database which has an integer parameter numBonIn, which returns a boolean value. …
java mysql stored-functionsI 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-functionsI have a table Processes, which consists of an ID (unsigned int, auto_increment) and Name (varchar, unique). Selecting the …
mysql sql stored-functionsI'm quite new to subject of writting stored function for mySQL database, hence i'm not sure if what i'm trying …
mysql stored-functionsWhen refactoring PostgreSql functions (and more specific: while searching for 'unused' functions) it would be handy to have a function …
postgresql refactoring stored-functionsI 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