sql-function Examples and Free Source Code

How to give select query a name in Postgres...

postgresql prepared-statement common-table-expression sql-view sql-function

Correctly escape a trailing backslash in a string within XML to JSON function?...

sql sql-server sql-function

Backticks not right in sql string...

php codeigniter query-builder sql-function quoting

Grouping repeated XML elements into JSON arrays...

sql sql-server sql-function

SQL date format convert? [dd.mm.yy to YYYY-MM-DD]...

mysql sql date format sql-function

Entity Framework Core equivalent of getting the int result similarly to the .ExecuteScalar("SEL...

c#entity-framework-core asp.net-core-webapi sql-function

How to make a CodeIgniter UPDATE query using set() with a value of NOW()...

php codeigniter sql-update query-builder sql-function

CodeIgniter where() parameter containing SQL function is being incorrectly quoted...

php mysql codeigniter where-clause sql-function

How to write a SQL function within CodeIgniter's where() method...

php mysql codeigniter activerecord sql-function

CodeIgniter is not correctly applying identifier quotes in CONCAT_WS() expressions...

php codeigniter activerecord escaping sql-function

Transposing the row into a column header and other as column value in Redshift SQL...

sql amazon-web-services amazon-redshift sql-function

Calling GROUP_CONCAT() within CodeIgniter's active record renders an invalid query...

php codeigniter activerecord escaping sql-function

Using GROUP_CONCAT() in the SELECT clause of a CodeIgniter active record script creates an invalid q...

php codeigniter activerecord escaping sql-function

CodeIgniter's active record using CONCAT_WS() in select() renders an invalid query...

php codeigniter activerecord escaping sql-function

Convert query with SQL function calls in SELECT clause to CodeIgniter active record...

php codeigniter select activerecord sql-function

Registering a SQL function with JPA and Hibernate...

java spring hibernate sql-function dialect

Msg 178, Level 15, State 1, Line 8 A RETURN statement with a return value cannot be used in this con...

sql sql-server sql-server-2008 t-sql sql-function

Table-Valued Function(TVF) vs. View...

sql-server sql-view sql-function

Passing array to WHERE IN on multiple columns in a function...

sql arrays postgresql plpgsql sql-function

PostgreSQL function has syntax error at IF. Why?...

sql postgresql plpgsql rdbms sql-function

Using function result in WHERE clause in PostgreSQL...

postgresql select where-clause sql-function

Reading Oracle boolean filed dbms_utility.is_cluster_database in statement...

oracle-database plsql oracle11g sql-function

Function vs. Stored Procedure in SQL Server...

sql sql-server t-sql stored-procedures sql-function

Set schema for objects referred to in postgres functions to same as the function itself...

sql postgresql sql-function

Memoizable functions - Snowflake...

snowflake-cloud-data-platform sql-function

Why is the explicit table name necessary in this Postgres Function?...

postgresql plpgsql sql-function

Check if variable contains x in PostgreSQL function...

regex postgresql sql-function

How do I create a PostgreSQL TRIGGER to automatically calculate columns after INSERT?...

postgresql sqlite triggers sql-insert sql-function

MySQL Cursor jumps out before it reaches the end...

mysql sql procedure sql-function

Syntax Error #1064 when using MariaDB JSON_REPLACE function...

syntax mariadb sql-function