Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in stored-functions

Optimizing a stored function call in SELECT and WHERE clauses

mysql stored-functions

How to use variables in "EXECUTE format()" in plpgsql

Error Code: 1422. Explicit or implicit commit is not allowed in stored function or trigger

Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?

Stored procedure does not exist, even after creating it

How to throw an error in MySql procedure?

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

Compute 2,3 quartile average in SQL

Search 'grep-alike' through PostgreSql functions

Why is it not recommended to use server-side stored functions in MongoDB?

How to use Table output from stored MYSQL Procedure

How to edit PostgreSQL stored procedure?

Functions vs procedures in Oracle

View stored procedure/function definition in MySQL

SQL Server - where is "sys.functions"?