stored-procedures Examples and Free Source Code

Create a stored procedure that iterates over another stored procedure?...

sql-server stored-procedures azure-synapse temp-tables

SQL Error [900] [42000]: ORA-00900: invalid SQL statement...

stored-procedures plsql oracle11g

MySQL - Kill all sleeping connections...

mysql database stored-procedures

How to use the value from a result set within a for loop in Snowflake stored procedure?...

stored-procedures snowflake-cloud-data-platform

Returning a Cursor from a stored procedure...

sql stored-procedures cursor

How to call a stored procedure in Spring Boot?...

spring spring-boot hibernate stored-procedures spring-data-jpa

Getting Invalid Identifier error of ORA - 00904 even when column name is same...

oracle-database stored-procedures with-statement

MySQL stored procedure error with two cursors in the same routine "ER_SP_CURSOR_NOT_OPEN: Curso...

mysql stored-procedures database-cursor

Cleaning up Cursors without Spaghetti and Duplicate Code?...

t-sql stored-procedures

In SSMS SP debugger, can "Watch" variable value length be increased above 255 character li...

debugging stored-procedures ssms visual-studio-debugging ssms-2012

alternative to xp_cmdshell bcp?...

sql-server stored-procedures xp-cmdshell

Invoke Stored Procedure and Return ID...

postgresql stored-procedures

SQL Error 1630: Function SUBSTRING does not exist.. huh?...

mysql stored-procedures

Based on a min and max id obtained from a table, how to calculate how many groups of records I can d...

oracle-database stored-procedures plsql

When should I use stored procedures?...

sql database stored-procedures

PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT "INOUT")...

php mysql stored-procedures

Snowflake - invoking Python code without creating UDF/Stored Procedure...

python stored-procedures snowflake-cloud-data-platform

TypeError: Connection.execute() got an unexpected keyword argument, when executing stored procedure...

python sql sql-server stored-procedures sqlalchemy

Stored procedure with inserts to two related tables failing on foreign key constraint...

postgresql stored-procedures plpgsql

Difference between stored procedures and extended stored procedures...

sql-server sql-server-2008 stored-procedures

Oracle stored procedure not executing and throwing error...

oracle-database stored-procedures

MSSQL server Stored procedure not returning output parameters when called from c++...

c++sql sql-server stored-procedures

Where clause not working in stored procedure, when working outside of it...

mysql stored-procedures dynamic-sql

In SQL Server, what does "SET ANSI_NULLS ON" mean?...

sql t-sql stored-procedures

sql search query for multiple optional parameters...

sql sql-server search stored-procedures

Dynamic pivot in oracle sql - Procedure...

sql oracle-database stored-procedures oracle11g pivot

Can Azure Logic Apps call a stored procedure with multiple select statements?...

azure stored-procedures azure-logic-apps

Snowflake stored procedure passing parameter...

stored-procedures snowflake-cloud-data-platform

Update count column from data in another table...

sql-server stored-procedures

How to use a stored procedure with my Entity Framework v4 + POCOs...

.net entity-framework stored-procedures entity-framework-4 poco