Re: SQL Server 7/2000 vs Oracle 8i

From: Kalen Delaney <kalen_delaney_at_hotmail.please_reply_on_public_forums.com>
Date: Thu, 31 Aug 2000 14:33:58 -0700
Message-ID: <#VTQYK5EAHA.275@cppssbbsa04>

SQL Server 2000 provides Instead-Of triggers, which fire prior to (and instead of) the insert, update or delete statement that caused the trigger to fire.

SQL Server 2000 has materialized views, which are called "Indexed Views"

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com



Phil <jsneth_at_aol.com> wrote in message
news:39b0c5e9.2634428_at_news.mindspring.com...


>

> Triggers in Oracle are extremely flexible.  With SQL Server (last time

> I checked), programmers were comparitively limited in the control they

> had over when a trigger executes.

>

> Oracle 8i's "materalized views" (like views, but actually store data

> for perfomance) are not a feature SQL Server has yet - I *think*.

Received on Thu Aug 31 2000 - 16:33:58 CDT