hello, i need to create a stored procedure, however i am not sure with the
syntax, what is the basic syntax of a store procedure? i am using informix
sql editor, and my database is built in inform...
http://www.experts-exchange.com/Database/Oracle/Q_10066453.html
Zones:
OracleDate Answered: 08/15/1998 Rating: 6.6 Views: 0
Need to know how to assign an SQL Server parameterized stored procedure as a recordsource on a form through code. I need to be able to modify the parameters at run-time. There are multiple users ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10103543.html
Zones:
MS AccessDate Answered: 12/04/1998 Rating: 6.8 Views: 0
Is there any way by which i could write a stored procedure which will accept a table name as a parameter and does certain records access using that table ?
Can stored procedures be made dynamic to ...
http://www.experts-exchange.com/Database/Sybase/Q_10169629.html
Zones:
SybaseDate Answered: 07/15/1999 Rating: 5.8 Views: 0
here's my sp
create procedure bt_BlankAnswer(argUserProcessId IN integer)
as
begin
insert into UserProcessAnswer
values (999, argUserProcessId, 1, 1, 1, '');
end
This is a way simplified exa...
http://www.experts-exchange.com/Database/Oracle/Q_10190600.html
Zones:
OracleDate Answered: 08/04/1999 Rating: 8.2 Views: 0
I would like to notify other applications when there is a change in the databse.
To do this I have created a trigger that executes a program that notifyes the applications that would like to know...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10256997.html
Zones:
MS SQL ServerDate Answered: 01/10/2000 Rating: 8.4 Views: 0
I'm trying to write a stored procedure to create sequences. I will be bulk loading tables, and then I will want to reset the sequence to the next appropriate number.
Example:
CREATE OR REPLA...
http://www.experts-exchange.com/Database/Oracle/Q_10294937.html
Zones:
OracleDate Answered: 02/15/2000 Rating: 6.0 Views: 4
Really basic stuff here. I just copied an example of making an ADODB.Connection, setting the .Provider, doing a .Open and having it display the provider. Problem is, I don't know how to execute t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10355092.html
Zones:
MS AccessDate Answered: 05/23/2000 Rating: 8.0 Views: 0
Hello
Here is some code. The intention is to scan the tblSupplier table and select only those records, based on the field su_name that begin with the same starting letter.
It does not work p...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10373356.html
Zones:
MS AccessDate Answered: 05/31/2000 Rating: 7.6 Views: 0
I've just started a new project and the error handling mechanism between the code and Oracle needs to addressed. Currently, the code calls a stored_procedure which returns a magic number (e.g., 45...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10435917.html
Zones:
DatabasesDate Answered: 06/13/2000 Rating: 7.4 Views: 0
Hi,
I have an Stored Procedure with a cursor
CURSOR Materials IS
SELECT DISTINCT c1, c2, c3, c4, c5
FROM A, B
WHERE A.f1 = B.f1
and A.fx = pParam
Then I do:
FOR aMat IN Materials LOO...
http://www.experts-exchange.com/Database/Oracle/Q_10598221.html
Zones:
OracleDate Answered: 07/03/2000 Rating: 7.0 Views: 0
