Re: Trigger and SP

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 18:54:54 -0500

Really? Can you point me to the ref in the BOL? Thanx. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com
.
"Brandon Lilly" <avarice@nospam.swbell.net> wrote in message 
news:E120A675-BBE6-410C-99F0-C3049BEBA84D@microsoft.com...
> A trigger cannot have a parameter passed to or from it.  Please describe
> what it is that you really want to accomplish.
Actually, a trigger CAN have a parameter passed FROM it to a stored 
procedure.
With that said, you should be careful with triggers, as one or MORE rows
might have been updated, so you have to take that into account when writing
the trigger.
Brandon

Relevant Pages

  • Re: Trigger Question
    ... Pro SQL Server 2000 Database Design - ... I just decided that if my trigger for delete was ... >> SQL Server MVP ... >>> UPDATE OrderDetail ...
    (microsoft.public.sqlserver.programming)
  • Re: Question: Triggers
    ... Shelling out to the OS is not a quick thing to do inside a trigger. ... Tibor Karaszi, SQL Server MVP ... I have a VB.NET application which searches for the existence of these ...
    (microsoft.public.sqlserver.server)
  • Re: Records not inserting...
    ... > I am totally new to SQL server. ... However, in a trigger, would I be ... test the effects of certain data modifications and to set conditions for ... UPDATE statements. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ...
    (comp.databases.oracle.server)
  • Re: TRIGGER (AFTER INSERT) and Store Procedure ... insert failed !
    ... >into SQL server, the record exist anyway! ... >If you refresh the data you will see the record... ... it gets refreshed after trigger excecution automatically. ... I don't know your monitoring system, but I guess that removing the result ...
    (microsoft.public.sqlserver.programming)
Loading