I did a test on a asp page to compare opening a rs with a command object vs opening it using a select.
a) rstest.open ocmd.execute
b) rstest.open "select * from...",oCN,0,1
both have the same ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20601375.html
Hi Everyone,
I have a trigger on a table that I want only to fire when a specific stored procedure is called. Is there a way to do this. ?
Thanks
Michele
http://www.experts-exchange.com/Database/Oracle/Q_20777128.html
Zones:
OracleDate Answered: 11/10/2003 Grade: B Views: 0
Hi Experts,
I want to control the use disk useage for webbase email accounts
My disk /etc/fstab is appended.
LABEL=/ / ext3 defaults 1 1
LABE...
http://www.experts-exchange.com/OS/Linux/Administration/Q_20974552.html
Zones:
Linux AdminDate Answered: 05/02/2004 Grade: A Views: 0
I'm trying to execute the following oracle procedure from my app:
CREATE OR REPLACE PROCEDURE sp_manual_order
(i_order_no IN tbl_orders.order_no%TYPE,
o_order_id OUT tbl_orders.orde...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21411610.htm...
How do you get into the /proc directory via the bash shell command line?
http://www.experts-exchange.com/OS/Linux/Q_21746268.html
Zones:
LinuxDate Answered: 02/26/2006 Grade: A Views: 0
Is there any possibility to rebuild proc file system ?
http://www.experts-exchange.com/OS/Linux/Administration/Q_21897831.html
Zones:
Linux AdminDate Answered: 06/24/2006 Grade: C Views: 0
i'm creating a proc for my ops desk to use as needed, such that they can do the SELECT INTO a new table if/when a dataset is in question. like 'oh, we need to delete all these trades...maybe' yo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22137902.html
I am a new to ProC/C++ .
Now i need to link two .pc file in a project .
eg:
there are two .pc file.
one.pc implement the function of select .
two.pc implement the function of insert .
I can ...
http://www.experts-exchange.com/Database/Oracle/Q_10187284.html
Zones:
OracleDate Answered: 09/08/1999 Grade: C Views: 0
I have Table1 as:
T1ID int PRIMARY KEY,
T1OwnNbr,
T1OprNbr
T1Desc
I have Table2 as:
T2ID int PRIMARY KEY,
T2OwnNbr,
T2OprNbr
I have my stored proc. as:
select T1.T1ID, T1.T1Desc
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10292504.html
We're trying to set up ORACLE 8.1.6 Parallel Server on AlphaOpen VMS.
Is there any production examples for setting up the following parameters?
- lm_ress
- lm_locks
- gc_releasable_locks
...
http://www.experts-exchange.com/Database/Oracle/Q_20063667.html
Zones:
OracleDate Answered: 05/26/2002 Grade: A Views: 0
