StackOverflow Questions for Tag: stored-procedures

mcv

Reputation: 1460

mysql how to pass null parameter into stored procedure and test for it in sql statement

mysqlstored-procedures

Score: 0

Answers: 2

Sunil Keshari

Reputation: 99

How to resolve An INSERT EXEC statement cannot be nested in SQL server

sql-serverdatabasestored-proceduresjava-stored-procedures

Score: 0

Answers: 1

Jeff Dege

Reputation: 11720

Msg 16929, The cursor is READ ONLY - why?

sqlsql-serverdatabasestored-procedurestriggers

Score: 3

Answers: 2

Manatax

Reputation: 4223

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

mysqlstored-procedures

Score: 219

Answers: 12

Kevin

Reputation: 9

Create a SQL Server stored procedure that can run against multiple databases

c#sqlsql-serverstored-procedures

Score: -1

Answers: 2

sagar limbu

Reputation: 1262

passing date as a parameter in stored procedure (oracle)

javaoracle-databasehibernatestored-procedures

Score: 1

Answers: 1

Chris

Reputation: 174

Trouble groking correct transaction handling in postgresql (16.x) procedures

postgresqlstored-procedures

Score: 0

Answers: 1

Abhisek Rajput

Reputation: 19

Does DBT has error handling feature like procedures

stored-procedureserror-handlingdbt

Score: -2

Answers: 0

NunoRibeiro

Reputation: 511

Petapoco execute stored procedure without waiting

c#sql-serverstored-procedurespetapoco

Score: 1

Answers: 1

Sam

Reputation: 171

Execute stored procedure with PetaPoco

stored-procedurespetapoco

Score: 16

Answers: 4

user323060

Reputation: 1

SQL Server Agent job to verify logshipping on multiple databases

sql-serverstored-proceduressql-agent-joblog-shipping

Score: 0

Answers: 0

Ruwanika

Reputation: 3

Syntax error: unexpected '='. when writing a Snowflake stored procedure

sqlstored-proceduressnowflake-cloud-data-platform

Score: 0

Answers: 2

srcourtepatte

Reputation: 1

Can a MySQL Procedure have a dubious IN type? IE. IN foo INT || VARCHAR(60)

mysqlstored-procedures

Score: 0

Answers: 1

chamibuddhika

Reputation: 1439

Oracle Ref cursor along with out parameters

stored-proceduresplsqloracle11gref-cursor

Score: 0

Answers: 2

Ismail

Reputation: 23

MySQL Stored Procedure failing / falling to deadlock when trying to insert a manually incremented unique key field

sqlmysqlstored-proceduresdeadlock

Score: 0

Answers: 0

ennezetaqu

Reputation: 25

ORA-12008: error in materialized view or zonemap refresh path and ORA-01722: invalid number when refreshing materialized views

oracle-databasestored-proceduresmaterialized-viewsdatastageora-01722

Score: 0

Answers: 0

Matthew Cassell

Reputation: 279

Passing stored procedure arguments to FOR loop cursor

stored-proceduresteradatateradata-sql-assistant

Score: 0

Answers: 2

Stefan de Beer

Reputation: 1

Firebird SQL stored procedure: IN clause using a parameter

stored-proceduresfirebird

Score: 0

Answers: 0

jjm

Reputation: 6198

Returning boolean from SQL function

sqlpostgresqlstored-proceduresplpgsql

Score: 8

Answers: 1

Maeaex1

Reputation: 755

Update multiple columns based on values of another table in stored procedure

oracle-databasestored-proceduressql-updateoracle19cdatabase-cursor

Score: 0

Answers: 2

PreviousPage 2Next

StackOverflow Questions for Tag: stored-procedures

mysql how to pass null parameter into stored procedure and test for it in sql statement

How to resolve An INSERT EXEC statement cannot be nested in SQL server

Msg 16929, The cursor is READ ONLY - why?

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation &#39;=&#39;

Create a SQL Server stored procedure that can run against multiple databases

passing date as a parameter in stored procedure (oracle)

Trouble groking correct transaction handling in postgresql (16.x) procedures

Does DBT has error handling feature like procedures

Petapoco execute stored procedure without waiting

Execute stored procedure with PetaPoco

SQL Server Agent job to verify logshipping on multiple databases

Syntax error: unexpected &#39;=&#39;. when writing a Snowflake stored procedure

Can a MySQL Procedure have a dubious IN type? IE. IN foo INT || VARCHAR(60)

Oracle Ref cursor along with out parameters

MySQL Stored Procedure failing / falling to deadlock when trying to insert a manually incremented unique key field

ORA-12008: error in materialized view or zonemap refresh path and ORA-01722: invalid number when refreshing materialized views

Passing stored procedure arguments to FOR loop cursor

Firebird SQL stored procedure: IN clause using a parameter

Returning boolean from SQL function

Update multiple columns based on values of another table in stored procedure

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Syntax error: unexpected '='. when writing a Snowflake stored procedure