Top "Stored-procedures" questions

Creating stored procedure and SQLite?

Is it somehow possible to create a stored procedure, when using SQLite?

sqlite stored-procedures

Return multiple fields as a record in PostgreSQL with PL/pgSQL

I am writing a SP, using PL/pgSQL. I want to return a record, comprised of fields from several different …

sql postgresql stored-procedures types plpgsql

Truncating a table in a stored procedure

When I run the following in an Oracle shell it works fine truncate table table_name But when I try …

oracle stored-procedures plsql ddl

How can I use Oracle SQL developer to run stored procedures?

* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number var …

oracle stored-procedures plsql oracle-sqldeveloper sys-refcursor

How to return temporary table from stored procedure

CREATE PROCEDURE [test].[proc] @ConfiguredContentId int, @NumberOfGames int AS BEGIN SET NOCOUNT ON RETURN @WunNumbers TABLE (WinNumb int) INSERT INTO @…

sql-server stored-procedures temp-tables

View stored procedure/function definition in MySQL

What is the MySQL command to view the definition of a stored procedure or function, similar to sp_helptext in …

mysql stored-procedures stored-functions

Granting Rights on Stored Procedure to another user of Oracle

I am a student of Undergraduate studies , and I am facing little problem in granting rights of ownership to a …

oracle stored-procedures grant owner rights-management

Looping Over Result Sets in MySQL

I am trying to write a stored procedure in MySQL which will perform a somewhat simple select query, and then …

mysql loops stored-procedures cursor

Using DateTime in a SqlParameter for Stored Procedure, format error

I'm trying to call a stored procedure (on a SQL 2005 server) from C#, .NET 2.0 using DateTime as a value to …

c# sql-server datetime stored-procedures .net-2.0

SQL Server 2000: How to exit a stored procedure?

How can I exit in the middle of a stored procedure? I have a stored procedure where I want to …

sql-server tsql stored-procedures sql-server-2000 control-flow