Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Updatable Views -Instead of trigger

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-06 : 12:23:12
Summer writes "Hi!

I use SQL server 7.
I have view where is joind two tables with left outer join.
I can not delete rows from that view. I think it's because of join, even it left outer join and I want to delete records from first table. Other updates (add/update) seem to work?

Do I have to use this Instead of trigger or is there some other way?
What should insted of delete trigger include?
I am not so good with triggers...

regards
Summer"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-06-06 : 12:45:59
Hasn't this been asked and answered?

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=16519

EDIT: There is not 'Instead Of' trigger in SQL 7...

<O>

Edited by - Page47 on 06/06/2002 12:47:15
Go to Top of Page
   

- Advertisement -