stored-procedures Examples and Free Source Code

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

MySQL 8.0 Stored Procedure Showing as Slow Query Due to Total Execution Time...

performance events stored-procedures mysql-8.0 mysql-slow-query-log

How to see stored procedure progress in Linux DB2?...

debugging stored-procedures db2-luw diagnostics

How to debug PL/SQL procedure performance issues in OceanBase...

stored-procedures database-cursor oceanbase

Why is static SQL in Linux DB2 stored procedure rejected?...

stored-procedures static db2-luw

Where should I commit a transaction -- in the Stored Procedure or in the calling application code?...

php oracle-database stored-procedures transactions

T-SQL stored procedure - error inserting the last variable...

sql sql-server t-sql stored-procedures

How to handle dynamic SQL generation safely in OceanBase stored procedures...

stored-procedures oceanbase

Can a Postgres Commit Exist in Procedure that has an Exception Block?...

postgresql stored-procedures plpgsql postgresql-11

Entity Framework Core - Using Stored Procedure with output parameters...

c#sql stored-procedures entity-framework-core

What to use as a NOOP in PostgreSQL?...

postgresql stored-procedures no-op

Is it possible to execute a stored procedure over a set without using a cursor?...

sql sql-server t-sql stored-procedures

Call large SQL queries from inside procedures or functions to create common helper functions in Snow...

sql stored-procedures snowflake-cloud-data-platform user-defined-functions

Snowflake SQL stored procedure: reference parameter in SQL query...

stored-procedures parameters snowflake-cloud-data-platform

The specified cast from a materialized 'System.Int32' type to the 'System.String' ty...

c#sql-server asp.net-web-api stored-procedures

Recursive stored procedure in OceanBase MySQL mode fails with error 2013 (lost connection)...

stored-procedures oceanbase

Stored procedure works on local but won't execute on server...

php mysql stored-procedures localhost

Liquibase templating stored procedure ChangeSets via <include> and <property>...

sql xml stored-procedures include liquibase

SQL Server: group dates by ranges...

sql sql-server stored-procedures group-by