stored-procedures Examples and Free Source Code

DB2/LUW How to Perform Cross-database Query Comparison without Federation?...

stored-procedures database-connection db2-luw

Size property has an invalid size of 0...

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

Writing and running a stored procedure asynchronously *and* getting a return value...

asynchronous stored-procedures snowflake-cloud-data-platform

Compare code between two stored procedures in two different databases in SQL Server...

sql sql-server t-sql stored-procedures

SQL Server stored procedure keeps waiting with "awaiting command"...

sql sql-server sql-server-2008 stored-procedures

What to use in SQL instead of a "Foreach" loop...

sql loops stored-procedures

How to pass a null variable to a SQL Server stored procedure from C# / .NET code...

c#sql sql-server stored-procedures

Oracle Error ORA-06512...

oracle-database stored-procedures plsql ora-06512

How can I automatically prepend comment blocks to SQL Server stored procedures?...

sql-server stored-procedures comments

DB2 LUW Why does use of a cursor predicate generate an error?...

stored-procedures predicate db2-luw database-cursor

Program logic to Update and Get data to/from same stored procedure...

c#stored-procedures thread-safety

Default Values to Stored Procedure in Oracle...

stored-procedures parameters plsql oracle11g default

Correct syntax to define parameters in a `StoredProcedure` Spring bean, fixing error ORA-06550...

spring oracle-database stored-procedures plsql

Must declare the scalar variable...

sql sql-server stored-procedures

DB2 LUW Why does TRANSLATE produce this error? SQLSTATE(42815)...

stored-procedures translate db2-luw

SQL Server: Invalid Column Name...

sql sql-server sql-server-2008 stored-procedures

TRIM in SELECT statement that works in Stand Alone Query Fails in Stored Procedure (MySQL)...

mysql stored-procedures whitespace trim removing-whitespace

Two multi select parameters in SSRS not displaying results for when selected more than one value...

sql sql-server stored-procedures reporting-services

Calling an API from SQL Server stored procedure...

sql-server stored-procedures

DB2 LUW - Get Compile-time Failing Line Number in Stored Procedure...

stored-procedures compile-time db2-luw diagnostics

Is there a simpler way to get the argument type list for a snowflake procedure?...

stored-procedures snowflake-cloud-data-platform

Select most recent record for each member...

sql-server sql-server-2008 t-sql stored-procedures

Getting the error detail of a Stored Procedure Activity in Azure Data Factory...

stored-procedures error-handling azure-data-factory

SQL Server IF EXISTS THEN 1 ELSE 2...

sql sql-server if-statement stored-procedures sql-server-2012

How can I select out parameters in a MySQL procedure as table columns?...

mysql sql stored-procedures

Update table column based on join in Oracle...

oracle-database join stored-procedures sql-merge

Fetch data between two dates in VB.NET from SQL Server by passing multiple parameter like @customerN...

asp.net sql-server vb.net stored-procedures

UNION the results of multiple stored procedures...

sql sql-server stored-procedures union

How stop execution of a stored procedure if the client closes the connection in SQL Azure database?...

sql-server azure stored-procedures

Is it possible for a Snowpark stored procedure to produce a DataFrame as its output?...

python dataframe stored-procedures snowflake-cloud-data-platform