Search code examples
Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?...

sql-serverdynamic-sql

Read More
Dynamic sql to retrieve volume count throwing incorrect syntax error...

sqldynamic-sql

Read More
How to return a table by rowtype in PL/pgSQL...

postgresqlpolymorphismplpgsqldynamic-sql

Read More
PostgreSQL drop constraint with unknown name...

postgresqlplpgsqldynamic-sqlpsql

Read More
Does the prepared SQL statements in a stored procedure make the performance better?...

sqldatabasestored-proceduresdb2dynamic-sql

Read More
Handle result when dynamic SQL is in a loop...

postgresqlcountplpgsqldynamic-sql

Read More
Create Temp Table Using Dynamic SQL...

sqlsql-serverdynamic-sql

Read More
Using OPENROWSET to dynamically retrieve SP results when SP contains # temp tables...

sqlsql-servert-sqldynamic-sqlopenrowset

Read More
Raise error in trigger to return insert row column...

sqlsql-servertriggersdynamic-sqlraiseerror

Read More
Dynamic SQL command not getting executed...

sql-serverdynamic-sqlsqlcommand

Read More
String concatenation using operator "||" or format() function...

postgresqlconcatenationdynamic-sql

Read More
Dynamic SQL (EXECUTE) as condition for IF statement...

postgresqldynamic-sqlplpgsql

Read More
Dynamically generate columns for crosstab in PostgreSQL...

postgresqlpivot-tableplpgsqldynamic-sqlpostgresql-9.1

Read More
Dynamic T-SQL - Alter column definition to max length of field...

sql-serverdynamic-sqlalter-column

Read More
Oracle DBMS_SQL giving ORA-1007 variable not in select list...

oracle-databaseplsqldynamic-sql

Read More
Select one value column from many in a pivot query...

sqlsql-serverpivotdynamic-sql

Read More
Will a column be dropped if I deleted it from information_schema.columns?...

postgresqldynamic-sqlalter-tableinformation-schemapostgresql-14

Read More
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
Cast value to type (TEXT) using string representation of type ("TEXT")...

sqlpostgresqlpolymorphismplpgsqldynamic-sql

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
BackNext