Triggers in SQL Server - triggers in Oracle

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Thu, 5 Oct 2000 14:58:51 -0700
Message-Id: <10640.118657@fatcity.com>

Hello!

We got our data warehouse running on Oracle 8i, but out client-side application is running on SQL Server 7. Now I'm kinda running into some problems of how to solve some issues in SQL server. I know how to do it in Oracle...

How can I achieve the following in SQL Server 7:

find out which application is issuing a query against the database

in Oracle, this would simply be a query on v$session

e.g. SELECT PROGRAM into myApplName

FROM v$session WHERE audsid = userenv('sessionid');

How can I achieve the same thing in SQL server?

b) how can I modify the values of variables inside a trigger?

the equivalent in Oracle would be:

IF :NEW.STATUS='A0' THEN
:NEW.STATUS:='AC'; Any ideas? Received on Thu Oct 05 2000 - 16:58:51 CDT