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
Does anyone know how to obtain current procedure's (ie the one where code is executing) name via code?
In other words is there a keyword or routine that will do a similar job for a procedure as "me...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10066491.html
Zones:
Visual BasicDate Answered: 07/23/1998 Rating: 8.2 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
Having just read the 'Hitchhikers Guide to Visual Basic and SQL Server' and being a DBA I support the view that data access and business functions are best modeled (if at all possible) using stored...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10127517.html
Zones:
VB DBDate Answered: 02/15/1999 Rating: 6.8 Views: 0
HI there, i have some stored procedures on a SQL server and i want to call them and received the result in my application built in Visual C++ 6.0. I connect to the server through ODBC. I read that ...
http://www.experts-exchange.com/Programming/Languages/CPP/Q_10152239.html
Zones:
C++Date Answered: 04/23/1999 Rating: 7.6 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: 4
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
Does anyone know of a 'Text2HTML function', i.e. a function that will take a string as input and as result return the same string, but now with all HTML-significant characters replaced by their HTM...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10228172.html
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: 0
