StackOverflow Questions for Tag: dynamic-sql

rMafia

Reputation: 75

How to create multiple files with different names and content using a comma-separated list without loops?

sqlmysqldynamic-sql

Score: 0

Answers: 0

WJTownsend

Reputation: 125

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

sql-serverdynamic-sql

Score: 0

Answers: 1

Jatin

Reputation: 45

Dynamic sql to retrieve volume count throwing incorrect syntax error

sqldynamic-sql

Score: -2

Answers: 2

thor

Reputation: 22530

How to return a table by rowtype in PL/pgSQL

postgresqlpolymorphismplpgsqldynamic-sql

Score: 3

Answers: 1

takteek

Reputation: 7110

PostgreSQL drop constraint with unknown name

postgresqlplpgsqldynamic-sqlpsql

Score: 11

Answers: 2

Aobo Yang

Reputation: 157

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

sqldatabasestored-proceduresdb2dynamic-sql

Score: 2

Answers: 3

sudoExclamationExclamation

Reputation: 8754

Switch ASC / DESC in ORDER BY with a CASE construct?

sqlpostgresqldynamic-sqlpostgresql-16

Score: 1

Answers: 4

Rémi Desgrange

Reputation: 908

Handle result when dynamic SQL is in a loop

postgresqlcountplpgsqldynamic-sql

Score: 1

Answers: 1

TrungT

Reputation: 35

Create Temp Table Using Dynamic SQL

sqlsql-serverdynamic-sql

Score: 1

Answers: 2

Zok Wobblefotz

Reputation: 353

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

sqlsql-servert-sqldynamic-sqlopenrowset

Score: 11

Answers: 4

Jay Edwards

Reputation: 25

Raise error in trigger to return insert row column

sqlsql-servertriggersdynamic-sqlraiseerror

Score: 0

Answers: 1

Kushan Randima

Reputation: 2300

Dynamic SQL command not getting executed

sql-serverdynamic-sqlsqlcommand

Score: 2

Answers: 1

user430926

Reputation: 4057

Select from dynamic table in function without using EXECUTE

functionpostgresqlsql-injectionplpgsqldynamic-sql

Score: 0

Answers: 2

HummingBird24

Reputation: 191

String concatenation using operator "||" or format() function

postgresqlconcatenationdynamic-sql

Score: 10

Answers: 1

Matt

Reputation: 4795

Dynamic SQL (EXECUTE) as condition for IF statement

postgresqldynamic-sqlplpgsql

Score: 21

Answers: 3

invinc4u

Reputation: 1185

Dynamically generate columns for crosstab in PostgreSQL

postgresqlpivot-tableplpgsqldynamic-sqlpostgresql-9.1

Score: 28

Answers: 4

Danny Rancher

Reputation: 2005

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

sql-serverdynamic-sqlalter-column

Score: 1

Answers: 4

Pro West

Reputation: 409

Oracle DBMS_SQL giving ORA-1007 variable not in select list

oracle-databaseplsqldynamic-sql

Score: 2

Answers: 1

user5024432

Reputation:

Dynamic SQL with CASE expression

sqlsql-serversql-server-2008sql-server-2008-r2dynamic-sql

Score: 0

Answers: 2

SoftwareDveloper

Reputation: 742

Select one value column from many in a pivot query

sqlsql-serverpivotdynamic-sql

Score: 1

Answers: 2

PreviousPage 1Next

StackOverflow Questions for Tag: dynamic-sql

How to create multiple files with different names and content using a comma-separated list without loops?

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

Dynamic sql to retrieve volume count throwing incorrect syntax error

How to return a table by rowtype in PL/pgSQL

PostgreSQL drop constraint with unknown name

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

Switch ASC / DESC in ORDER BY with a CASE construct?

Handle result when dynamic SQL is in a loop

Create Temp Table Using Dynamic SQL

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

Raise error in trigger to return insert row column

Dynamic SQL command not getting executed

Select from dynamic table in function without using EXECUTE

String concatenation using operator &quot;||&quot; or format() function

Dynamic SQL (EXECUTE) as condition for IF statement

Dynamically generate columns for crosstab in PostgreSQL

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

Oracle DBMS_SQL giving ORA-1007 variable not in select list

Dynamic SQL with CASE expression

Select one value column from many in a pivot query

String concatenation using operator "||" or format() function