New posts in dynamic-sql

Declare Variable for a Query String

sql sql-server sql-server-2005 tsql dynamic-sql

dynamic sql query in postgres

postgresql dynamic-sql psql

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

sql sql-server tsql dynamic-sql

Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?

oracle plsql dynamic-sql execute-immediate

PostgreSQL parameterized Order By / Limit in table function

sql database postgresql dynamic-sql plpgsql

nvarchar(max) still being truncated

sql sql-server-2008 dynamic-sql

Executing multiple dynamic statements together over linked server

sql sql-server tsql dynamic-sql

Define table and column names as arguments in a plpgsql function?

function postgresql variables plpgsql dynamic-sql

Getting result of dynamic SQL into a variable for sql-server

sql sql-server sql-server-2005 tsql dynamic-sql

SQL update fields of one table from fields of another one

sql postgresql sql-update dynamic-sql

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

sql postgresql roles dynamic-sql

Drop all tables whose names begin with a certain string

sql sql-server dynamic-sql

Truncating all tables in a Postgres database

postgresql plpgsql dynamic-sql truncate database-table

INSERT with dynamic table name in trigger function

postgresql triggers dynamic-sql plpgsql

How to get sp_executesql result into a variable?

tsql dynamic-sql

In SQL Server, how do I generate a CREATE TABLE statement for a given table?

sql-server scripting dynamic-sql

Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

sql dynamic-sql

Refactor a PL/pgSQL function to return the output of various SELECT queries

sql database postgresql plpgsql dynamic-sql

Table name as a PostgreSQL function parameter

function postgresql plpgsql dynamic-sql identifier