SQL Server Forums - SQL SERVER trigger

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL SERVER trigger

New Topic

Reply to Topic

Printer Friendly

Author

Topic

manasbagde
Starting Member

India
11 Posts

Posted - 10/14/2010 : 12:24:53

Could some one let me know what the below trigger will do?

use default_epayments_db
CREATE TRIGGER EBS_Update_URL
ON
REQ
FOR INSERT
AS
BEGIN
IF EXISTS(SELECT RQ_REQUEST_ID, RQ_REQUEST_SERVER FROM REQ
WHERE RQ_REQUEST_SERVER = 'https://employeerequest-qa.emdeon.net/itg/')
BEGIN

update REQ set RQ_REQUEST_SERVER= 'http://10.145.176.21:8080/itg'

END
END

Regards,
Manas

--Manas

Kristen
Test

United Kingdom
22191 Posts

Posted - 10/14/2010 : 12:47:04

When a row(s) are inserted into table REQ, regardless of the values in that row(s), if a row exists in REQ where RQ_REQUEST_SERVER = 'https://employeerequest-qa.emdeon.net/itg/' then RQ_REQUEST_SERVER will be set to 'http://10.145.176.21:8080/itg' for every row in table REQ.

I very much doubt this is the intended behaviour (unless there is a constraint that only allows there to be one row in REQ table, or somesuch)

Edited by - Kristen on 10/14/2010 12:47:48