Top "Stored-procedures" questions

A subroutine available to applications accessing a relational database system.

Entity Framework Stored Procedure Table Value Parameter

I'm trying to call a stored procedure that accepts a table value parameter. I know that this isn't directly supported …

c# entity-framework stored-procedures ef-code-first table-valued-parameters
SQL Differences between stored procedure and triggers

I'm having trouble understanding the difference between a stored procedure and a trigger in sql. If someone could be kind …

sql stored-procedures triggers
Get return value from stored procedure

I'm using Entity Framework 5 with the Code First approach. I need to read the return value from a stored procedure; …

c# stored-procedures ef-code-first entity-framework-5 return-value
How to raise an error within a MySQL function

I've created a MySQL function and would like to raise an error if the values passed for the parameters are …

mysql function exception stored-procedures
How to call a stored procedure in IBM System i Access for Windows GUI Tool

I would like to test a DB2 stored procedure running on an AS400 system. I have the IBM System i …

stored-procedures db2 ibm-midrange
Adding stored procedures complex types in Entity Framework

I am trying to use a stored procedure in Entity Framework that returns nothing. I did the following: Added a …

c# stored-procedures entity-framework-4 silverlight-4.0
How can I generate a temporary table filled with dates in SQL Server 2000?

I need to make a temporary table that holds of range of dates, as well as a couple of columns …

sql tsql stored-procedures sql-server-2000
How do I find out when a stored procedure was last modified or compiled in Oracle?

I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.

sql oracle stored-procedures plsql oracle10g
SQL Transaction was deadlocked

Sometimes I get this kind of exception on not very busy SQL server: Transaction (Process ID 57) was deadlocked on lock …

sql-server exception stored-procedures triggers
UNION the results of multiple stored procedures

I have a stored procedure I need to call several different times passing in different paramaters each time. I would …

sql sql-server stored-procedures union