stored-procedures Examples and Free Source Code

SQL ignore part of WHERE if parameter is null...

sql database sql-server-2008 stored-procedures

Trying to execute a simple stored procedure - Help! Can't find an answer that works here...

sql oracle stored-procedures plsql execute

Passing Output parameters to stored procedure using dapper in c# code...

c#sql sql-server stored-procedures dapper

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

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

Self join to compare rows of table?...

sql sql-server stored-procedures

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 stored-procedures with-statement

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

Call a stored procedure with parameter in c#...

c#asp.net sql-server stored-procedures ado.net

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 stored-procedures plsql

When should I use stored procedures?...

sql database stored-procedures

Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handl...

mysql stored-procedures database-cursor

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

php mysql stored-procedures

How to enter cursor as an input in procedure oracle...

sql oracle stored-procedures cursor

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

How to get row number using sql stored procedure...

mysql stored-procedures