Tag: dynamic-sql


Found 166 results for 'dynamic-sql'.


1) postgresql - use variable to determine the name of a column in the select in Postgres
2) postgresql - PostgreSQL trigger function that selects from %current% table
3) postgresql - Check whether empty strings are present in character-type columns
4) postgresql - Passing array from one plpgsql function to another
5) postgresql - Find changed columns for near-identical rows across tables
6) trigger - Pass Parameters to trigger function to execute dynamic SQL
7) postgresql - Trigger function using current row and current table name as variables
8) sql-server - User-shared queries: Dynamic SQL vs. SQLCMD
9) postgresql - PostgreSQL and storing configs
10) sql-server - How to mention declared integer in where condition using dynamic sql?
11) sql-server - Execution time high for Query in sp_executesql
12) postgresql - How to create function(table_name) that returns a set of the table
13) postgresql - How to create a table dynamically based on json data?
14) postgresql - Preparing query in postgreSQL with variable table name?
15) postgresql - Create stored procedure with dynamic number of columns + column names
16) postgresql - Dynamically convert hstore keys into columns for an unknown set of keys
17) sql-server - Dynamic SQL - How can you use it to run a SELECT against all schema's and Tables?
18) postgresql - Trigger function taking column names as parameters to modify the row
19) postgresql - Trigger function using current row and current table name as variables (final part)
20) trigger - Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function
21) trigger - EXECUTE stmt USING expression
22) postgresql - How to get max field value length for each TEXT field in all tables in database
23) postgresql - How to use function parameters in dynamic SQL with EXECUTE?
24) mysql - How to create dynamic columns using prepared statements in MySQL?
25) function - Table name as a PostgreSQL function parameter
26) sql-server - Dynamic conversion of long data to wide with multiple columns
27) php - Statement work on phpmyadmin but not through php
28) sql-server-2016 - How to insert into temp table on Server A results from dynamic SQL open query stored proc call to remote server B via Remote Query showplan operator?
29) sql-server - Use Dynamic SQL To Create View From Cursor
30) postgresql - PostgreSQL - Return type and EXECUTE QUERY
31) sql-server - Build dynamic text search on table columns
32) sql-server - sp_executesql adds statements to executed dynamic script?
33) postgresql - SELECT rows based on indefinite number of filters
34) sql-server - SQL Server Extend dynamic SQL query with where part fetched from Stored Procedure
35) sql-server-2008 - Dynamic SQL To Send HTML Email
36) oracle - Set columns dinamically in UTL_FILE
37) oracle - Facing error while trying to run dynamic pl/sql
38) sql-server - Update various tables depending on survey answer
39) sql-server - Selecting multiple values from a column and put them into separate columns
40) sql-server - metadata could not be determined because stored procedure contains dynamic SQL
41) postgresql - Function taking a string as table and column name
42) postgresql - Duplicate row with Primary Key in PostgreSQL
43) sql-server - Select permission inside stored procedure?
44) mariadb - MariaDB: Create dynamic PrepareStatement inside a Procedure
45) postgresql - Safely quoting type names to protect against SQL-injection
46) postgresql - How to drop all of my functions in PostgreSQL?
47) sql-server - Help error message inside dynamic T-SQL
48) sql-server - Create DDL Trigger Dynamically
49) t-sql - Stored procedure with dynamic sql. Is it isolation safe by default?
50) oracle - Why can't we use strong ref cursor with dynamic SQL Statement?