Need A MSSQL Trigger

[idumlupinar]

Hello guys, i am using a module. I want to run a query whenever user updates an article. Reason is: During article update Fileid becomes FileID under ImageURL column, and this causes broken image paths for my case. I want to keep this Fileid thing same whenever an update occurs at database table. Following trigger works for new entries: CREATE TRIGGER FileID_replace ON Articles AFTER INSERT AS BEGIN update Articles set ImageUrl=REPLACE(ImageUrl,'FileID','Fileid') where ArticleID = (select max(ArticleID) as ArticleID from Articles) END However i need a one to keep Fileid whenever an update occurs. Would you please help? Thank you.

[Not Active]

So create an UPDATE trigger. What difficulties are you having?

---

I know the language. I've read a book. - _Madmatt

[idumlupinar]

Can you tell me which query to use? I tried one, but it works for only latest entry. If editing a previous entry, it does not work. Because my query was relying on increase on articleId.

[Not Active]

Maybe you'd like to show what you have tried.

---

I know the language. I've read a book. - _Madmatt

[idumlupinar]

Sure: (I simply changed AFTER CREATE with AFTER UPDATE) But i guess i am missing something. I tried following: CREATE TRIGGER FileID_replace ON Articles AFTER UPDATE AS BEGIN update Articles set ImageUrl=REPLACE(ImageUrl,'FileID','Fileid') where ArticleID = (select max(ArticleID) as ArticleID from Articles) END GO

[Not Active]

Of course these queries are only going to work for the last record, that's what you're asking for.

idumlupinar wrote:

select max(ArticleID)

If you read the documentation for triggers you will understand. Query the inserted or updated to get the record currently being affected.

---

I know the language. I've read a book. - _Madmatt

[idumlupinar]

Well, i am not a SQL Developer yet, i am trying to learn anyway :) Can you share an url that would explain my case clearly? I reviewed a few resources but i couldn't understand most of them :(

[Md Marufuzzaman]

Try like this:

DECLARE @MyId VARCHAR(50)
SET @MyId = SELECT ID FROM INSERTED
UPDATE ........ WHERE ID = @MyId

Thanks Md. Marufuzzaman

---

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.