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 Rating: 7.2 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
Zones:
MS SQL ServerDate Answered: 03/31/2001 Rating: 8.2 Views: 0
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
Zones:
MS SQL ServerDate Answered: 09/19/2001 Rating: 6.4 Views: 0
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
Zones:
MS SQL ServerDate Answered: 11/28/2003 Rating: 8.8 Views: 0
SQL Server 2000
Hello,
I want to create an INSERT trigger.
and to make an update (With A condition)
Just on the current row that was inserted .
so it look like this :
CREATE TRIGGER t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20416055.html
Zones:
MS SQL ServerDate Answered: 12/05/2002 Rating: 9.4 Views: 0
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
Zones:
MS SQL ServerDate Answered: 04/03/2003 Rating: 9.6 Views: 0
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
Zones:
MS SQL ServerDate Answered: 07/04/2004 Rating: 7.8 Views: 0
Morning experts.
I am trying to come up with the best way to notify customers, whos information is stored in a database, through email, when alerts are thrown for specific records.
Things to ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20920637.html
Zones:
MS SQL ServerDate Answered: 03/18/2004 Rating: 6.2 Views: 0
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
Zones:
MS SQL ServerDate Answered: 04/08/2004 Rating: 8.4 Views: 0
I'm somewhat new to SQL Server, so a step-by-step will be helpful. I want to create a trigger that will alert me via net send when a specific entry is entered in a table.
How do I create this ty...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21060233.html
Zones:
MS SQL ServerDate Answered: 07/16/2004 Rating: 8.6 Views: 0