StackOverflow Questions for Tag: dynamic-sql

Jatin

Reputation: 47

Dynamic sql to retrieve volume count throwing incorrect syntax error

sqldynamic-sql

Score: -1

Answers: 2

thor

Reputation: 22460

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: 8690

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: 2282

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: 4775

Dynamic SQL (EXECUTE) as condition for IF statement

postgresqldynamic-sqlplpgsql

Score: 19

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: 744

Select one value column from many in a pivot query

sqlsql-serverpivotdynamic-sql

Score: 1

Answers: 2

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

PreviousPage 1Next

StackOverflow Questions for Tag: dynamic-sql

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

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

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