Tag: stored-procedures

Found 545 results for 'stored-procedures'.

---

1) postgresql - Postgres 12: Inserting array of composite types, composite type has an array field. Malformed array literal, unexpected end of input
2) postgresql - Proper use of database functions for business logic
3) mysql - Splitting large database into smaller ones
4) postgresql - Insert Array of JSON into Postgres Table
5) postgresql - In PostgreSQL, what is the difference between a "Stored Procedure" and other types of functions?
6) postgresql - Update Postgres Table with Array of JSON
7) mysql - Performance of a Trigger vs Stored Procedure in MySQL
8) mysql - Unable to update table after creating an After update trigger
9) postgresql - What are the privileges required to execute a trigger function in PostgreSQL 8.4?
10) mysql - How to insert a record with generated identifiers using UUID()?
11) sql-server - Creating a helper UDF or stored procedure and limiting external access
12) database-design - Proper use of NULL, and utilizing CHECK constraints for business logic vs stored procedures
13) mysql - How to Solve ERROR 1064 (42000)?
14) postgresql - How can I Run stored procedures in public schema to provision and create tables in a new schema
15) sql-server - Is there a performance consideration if stored procedures are in a separate database than the source data?
16) sql-server-2008 - Stored Procedure Consolidation
17) mysql - Recursive Query in MySQL using stored proceedure and CURSOR
18) oracle - Procedure with "bind varibale" does not return the desired result set
19) mysql - MySQL LIKE IN with Input Parameter of stored procedure Comma Separated Values
20) mysql - Nested Cursors in Mysql problem with FETCH
21) sql-server - How to compute number of concurrent application sessions using SQL Server table storing session data?
22) mysql - Join multiple table with unique data
23) oracle - How to pass data and loop in procedure Oracle
24) sql-server - Inconsistent Execution Plan for Stored Procedure
25) sql-server - Execution time of a stored procedure
26) oracle - Running a stored procedure across db Link
27) mysql - MySQL Stored Procedure - no of times executed
28) sql-server - OPTIMIZE FOR UNKNOWN in a Stored Procedure
29) sql-server-2012 - Xquery, insert, Trigger and no place to squeeze stored procedure
30) postgresql - Create stored procedure with dynamic number of columns + column names
31) postgresql - Concatenation of setof type or setof record
32) mysql - if else loop only iterating once
33) mysql - Call a stored procedure from a trigger
34) mysql - mySql while loop ending after a insert
35) sql-server - Dynamic SQL Server cross tab
36) mysql - MySQL : Stored Procedure from Trigger giving duplicate results
37) mysql - MySQL Subquery returns more than one row
38) performance - Is using triggers best solution for this scenario
39) design - Modern practices for stored procedure-based applications
40) design - When should I use stored procedures?
41) asp.net - Entity Framework 6 and Stored Procedures
42) c# - A CLR SQL Server Stored Procedure calling an ASP.NET Web API
43) postgresql - PostgreSQL procedural languages - differences between PL/pgSQL and SQL
44) sql-server - Why does truncating a temp table at the end of the stored procedure that creates it free tempdb space faster?
45) mysql - MYSQL Stored procedure to fetch entire row from a table
46) sql-server - With the advent of integrated source control, do stored procedure changes still need comments?
47) mysql - MySQL replication -- issue with mysql.proc during replication from 5.0 to 5.5 host
48) mysql - SQL - Restricted view for transient (stateless) user
49) sql-server - Stored procedure execution time went from under 2mins to "infinity" without modifications
50) sql-server-2016 - Stored Procedure Signed by Certificate Unable to Add Members to Database Roles

---