StackOverflow Questions for Tag: dynamic-sql

Prosto_Oleg

Reputation: 376

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

postgresqldynamic-sqlalter-tableinformation-schemapostgresql-14

Score: 0

Answers: 1

mf.cummings

Reputation: 315

Dynamic SQL BCP on local desktop writes no file and generates no error

ssmsdynamic-sqlbcp

Score: 0

Answers: 0

sodaCodes

Reputation: 5

How to return columns from dynamic SQL in Python console

pythonoracle-databaseplsqldynamic-sqlcx-oracle

Score: 0

Answers: 2

StevenU

Reputation: 39

Dynamic Oracle Query, without dynamic

oracle-databasedynamic-sql

Score: 0

Answers: 1

arthur

Reputation: 1064

Update record of a cursor where the table name is a parameter

postgresqlsql-updateplpgsqldynamic-sqldatabase-cursor

Score: 8

Answers: 1

Delta Soares

Reputation: 1

Execute dynamic inserts in a procedure

postgresqlplpgsqldynamic-sql

Score: 0

Answers: 2

douglas_forsell

Reputation: 131

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

sqlpostgresqlplpgsqlwindow-functionsdynamic-sql

Score: 1

Answers: 1

Rancha124

Reputation: 43

How to query a dynamic list of strings using SQL?

sqlsql-serverdynamic-sqlsql-server-2022

Score: 0

Answers: 1

MRodriguez

Reputation: 419

PostgreSQL Dynamic Query Execution with Table-Valued Variables

postgresqlscopeplpgsqldynamic-sqlexecute

Score: 1

Answers: 1

GammaGames

Reputation: 1828

Cast value to type (TEXT) using string representation of type ("TEXT")

sqlpostgresqlpolymorphismplpgsqldynamic-sql

Score: 1

Answers: 1

slevin

Reputation: 3886

concatenate additional text to string variable in pl/pgsql

postgresqlconcatenationplpgsqldynamic-sql

Score: 4

Answers: 1

TemNyilv

Reputation: 1

Group_Concat() when is null, I get error 1064

sqlmysqlmariadbdynamic-sql

Score: 0

Answers: 0

Allard

Reputation: 11

Oracle PL/SQL: generic and uniform journalling trigger without hardcoding columns in the trigger

sqloracle-databaseplsqltriggersdynamic-sql

Score: 1

Answers: 1

saif barakat

Reputation: 1

I am trying to use dynamic SQL query to generate dynamic columns but I received an error in MySQL

sqlmysqldynamic-sql

Score: 0

Answers: 0

James De Souza

Reputation: 668

Function to return dynamic set of columns for given table

postgresqlfunctionplpgsqldynamic-sql

Score: 5

Answers: 2

user3673794

Reputation: 11

Filter column names from existing table for SQL DDL statement

sqlpostgresqldynamic-sql

Score: 1

Answers: 1

Stephen

Reputation: 1

How to assign a column to a variable in Dynamic SQL

sql-serverdynamic-sql

Score: 0

Answers: 1

bzm3r

Reputation: 4605

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

sqldynamic-sqlduckdb

Score: 2

Answers: 2

Michael M

Reputation: 8763

Change schema of multiple PostgreSQL functions in one operation?

sqlpostgresqlschemadynamic-sqlddl

Score: 2

Answers: 2

Awaish Kumar

Reputation: 557

Function returning a table for given table and column names

sqlpostgresqlplpgsqldynamic-sql

Score: 1

Answers: 2

PreviousPage 2Next

StackOverflow Questions for Tag: dynamic-sql

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

Dynamic SQL BCP on local desktop writes no file and generates no error

How to return columns from dynamic SQL in Python console

Dynamic Oracle Query, without dynamic

Update record of a cursor where the table name is a parameter

Execute dynamic inserts in a procedure

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

How to query a dynamic list of strings using SQL?

PostgreSQL Dynamic Query Execution with Table-Valued Variables

Cast value to type (TEXT) using string representation of type (&quot;TEXT&quot;)

concatenate additional text to string variable in pl/pgsql

Group_Concat() when is null, I get error 1064

Oracle PL/SQL: generic and uniform journalling trigger without hardcoding columns in the trigger

I am trying to use dynamic SQL query to generate dynamic columns but I received an error in MySQL

Function to return dynamic set of columns for given table

Filter column names from existing table for SQL DDL statement

How to assign a column to a variable in Dynamic SQL

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

Change schema of multiple PostgreSQL functions in one operation?

Function returning a table for given table and column names

Cast value to type (TEXT) using string representation of type ("TEXT")