Search code examples
How to return columns from dynamic SQL in Python console...


pythonoracle-databaseplsqldynamic-sqlcx-oracle

Read More
Update record of a cursor where the table name is a parameter...


postgresqlsql-updateplpgsqldynamic-sqldatabase-cursor

Read More
How to declare variables and use them to UPDATE each row based on the preceding row(s)...


sqlpostgresqlplpgsqlwindow-functionsdynamic-sql

Read More
How to query a dynamic list of strings using SQL?...


sqlsql-serverdynamic-sqlsql-server-2022

Read More
concatenate additional text to string variable in pl/pgsql...


postgresqlconcatenationplpgsqldynamic-sql

Read More
Function to return dynamic set of columns for given table...


postgresqlfunctionplpgsqldynamic-sql

Read More
DuckDB: how do I create a table containing a column with a specific name from a `CREATE MACRO ... AS...


sqldynamic-sqlduckdb

Read More
Change schema of multiple PostgreSQL functions in one operation?...


sqlpostgresqlschemadynamic-sqlddl

Read More
Function returning a table for given table and column names...


sqlpostgresqlplpgsqldynamic-sql

Read More
Query string argument of EXECUTE is null...


databasepostgresqlplpgsqlpsqldynamic-sql

Read More
Dynamically selecting the column to select from the row itself in SQL...


sqlsql-serverdynamic-sql

Read More
Create PostgreSQL ROLE (user) if it doesn't exist...


sqlpostgresqlrolesdynamic-sql

Read More
Creating the same view in multiple tenant databases using a stored procedure...


sqlsql-servert-sqlmulti-tenantdynamic-sql

Read More
How to create a view of a query generated by another dynamic (meta) query...


sqlpostgresqlpivot-tabledynamic-sql

Read More
Dynamic SQL vs. generic query with dynamic filters...


sqlpostgresqlperformancequery-optimizationdynamic-sql

Read More
sp_executesql In Loop Taking FOREVER to Run. Slowing down as it runs. Memory Leak?...


sql-servert-sqldynamic-sqlsp-executesql

Read More
sp_executesql Not Returning Correct Value Using OUTPUT...


sql-serverdynamic-sqlsp-executesql

Read More
Macros / Meta-programming in Postgres queries...


sqlpostgresqlplpgsqldynamic-sql

Read More
Where clause not working in stored procedure, when working outside of it...


mysqlstored-proceduresdynamic-sql

Read More
Unable to compare a string with a UNIQUEIDENTIFIER...


sqlsql-serversql-server-2012dynamic-sql

Read More
Reliable way to retrieve all UNIQUEIDENTIFIER values from all columns...


sqlsql-serversql-server-2012dynamic-sql

Read More
How to SELECT without error if table does not exist...


sqlpostgresqlplpgsqldynamic-sql

Read More
How to club multiple select queries from one single table...


sqlpostgresqldynamic-sql

Read More
How to EXECUTE a set of stored procedures in a table...


sql-servert-sqlstored-proceduresdynamic-sqlexecute

Read More
Variables for identifiers inside IF EXISTS in a plpgsql function...


postgresqlpostgresql-9.1plpgsqldynamic-sqlexists

Read More
SQL Multiple Value Dynamic pivot...


sql-serverpivotsql-server-2016dynamic-sql

Read More
How to pass OLD, NEW and identifiers to EXECUTE in a trigger function?...


databasepostgresqltriggersplpgsqldynamic-sql

Read More
Counting the number of rows per view and table on SQL Server...


sql-serverdynamic-sqlinformation-schema

Read More
How to solve ERROR: operator is not unique: "unknown" - "unknown" in a dynamic S...


sqlstored-proceduresamazon-redshiftplpgsqldynamic-sql

Read More
Putting timestamp in a COMMENT ON TABLE...


postgresqltimestampdynamic-sqlddlpostgresql-9.4

Read More
BackNext