Re: trigger issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 12:15:08 +0100

> I have a function in ms sql server
>
> in which i m updating a table and returning one value
>
> and suppose,the table which gets updated has trigger which create a
table
> or modifies the table structure.
>
> wht will happen in this case.

Well... If you run that function, the table will be updated by the UDF,
trigger will be fired and its script executed, as a result of this a table
will be created or modified, and the function will return a value.
But this is exactly what you wrote in your post, I have added nothing. Maybe
I misunderstood your question, could you please explain your problem in more
details?

sincerely, 

--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Why is modifying inserted rows in a trigger so slow?
    ... The update you're doing is updating ALL rows. ... >I have an insert trigger that modifies the rows that have just been ... The trigger looks like: ... >updating the newly inserted rows take so long? ...
    (microsoft.public.sqlserver.programming)
  • trigger issue
    ... I have a function in ms sql server ... in which i m updating a table and returning one value ... and suppose,the table which gets updated has trigger which create a table ... wht will happen in this case. ...
    (microsoft.public.sqlserver.server)
  • Re: trigger quiz
    ... It is meant for view updating, ... I was only pointing out that the code as written wouldn't compile on SQL Server. ... modification within your trigger code. ...
    (microsoft.public.sqlserver.programming)
  • 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)