I am trying to dynamically access the data in :old and :new fields without
having to use the literal :old.field and :new.field..
The trigger below shows 2 ways of calling the p_addnote procedur...
http://www.experts-exchange.com/Database/Oracle/Q_20003650.html
Zones:
OracleDate Answered: 12/12/2000 Grade: B Views: 0
I have two SQL tables!!
If i insert somehting in one table...the other one should be updated!!
Please suggest
ITS URGENT
Regards
AmanBhatia
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20099479.html
Simple question...i need the code to do delete cascade. Table 1 is the parent table and Table 2 is the child table. I got about 2 millions to do so i don't really have time to learn T-SQL right ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20184471.html
Actually i want to create a trigger and looking for some examples.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20378822.html
I'm working on a time management system with the follwing capability:
Employees enter their time from when to when they are working.
Know some of them enter more than one pairs per day (e.g. 2...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20571527.html
I'm planning to write a script on UNIX server to remotely trigger SQL Server backup. My SQL Server is installed on Windows 2000 server. I have no idea how to do it right now. Does anyone have any c...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20578470.html
In my trigger for insert, there are some sql statements. I want to know which sql statement causes error and what's the error number. But it seems only the whole batch is rolled back when an error ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20947939.html
Newbie to SQL server 2000 and still learning on how to create trigger for database..I need to do 3 trigger for my database..
I have 2 tables to maintain information of his members and their mem...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21103767.html
Hi,
I am updating SQL 2000 tables through a VB application (connection via ado). Is there a way I can disable the triggers on the table I am updating only within the application. i.e. If anot...
http://www.experts-exchange.com/Programming/Misc/Q_21178756.html
Zones:
ProgrammingDate Answered: 12/27/2004 Grade: A Views: 0
hi,,,
i'm trying to make a small popup html window on the right bottom corner of user screen,,
this window is created based on a tigger on a table ,when ever
a row is inserted to a user a wind...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/HTML/Q_21212834.ht...
Zones:
HTMLDate Answered: 03/16/2005 Grade: A Views: 0
