Top "Create-function" questions

Incompatible object type when create and alter a table value function in SQL

I'm getting the below error for the given function. Msg 2010, Level 16, State 1, Procedure GetTableFromDelimitedValues, Line 2 Cannot perform alter on 'dbo.…

sql sql-server sql-server-2008 sql-function create-function

MySQL stored function with nested IF... END IF, error in syntax, right syntax to use near ''

I have a function that I currently use in PHP which compiles a mailing address from separate fields but takes …

mysql mysql-error-1064 stored-functions create-function

How to fix MySQL CREATE FUNCTION query?

I want to add mysql function: CREATE FUNCTION `chf_get_translation`(translation_id INT, site_lang INT) RETURNS text CHARSET …

mysql mysql-error-1064 create-function

Error SQL0104 when creating a function in System i V7R1

I'm creating a SQL function on System i V7R1: CREATE FUNCTION MYSCHEMA.GROUPDIBAS(v_code VARCHAR(50)) RETURNS VARCHAR(2048) LANGUAGE …

sql for-loop ibm-midrange create-function db2-400

How to replace postgresql function body?

In the DOC only described how to change function definition. But I have only function body changed (text between $$ sql $$). …

postgresql create-function