Re: How can i call a Trigger in ASP.NET ?
From: Shan Plourde (------_at_---.net)
Date: 07/28/04
- Next message: Eliyahu Goldin: "Re: populate DropDownList from DB"
- Previous message: Viktor Popov: "Re: populate DropDownList from DB"
- In reply to: Ricardo Corsi: "How can i call a Trigger in ASP.NET ?"
- Next in thread: Thomas Dodds: "Re: How can i call a Trigger in ASP.NET ?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 12:31:31 GMT
Triggers are not like stored procedures or functions. Normally you can
decompose your trigger logic into 2 items, 1 being the trigger, the
other being a stored procedure that the trigger can then call. This way,
you can also call the stored procedure from ASP.NET.
If that is not possible, a kludge is to issue a SQL statement that will
fire the trigger. For example, if you have an update trigger on column
XYZ, then if you issue an UPDATE table SET XYZ = XYZ (dummy SQL
statement to force trigger fire), that should do it, but I wouldn't
recommend it over the first option.
Shan
Ricardo Corsi wrote:
>Hi,
>
>It is possible to call a trigger (inside a sql server..) with asp.net ? how
>can i do that ?
>thks!
>
>
>
>
- Next message: Eliyahu Goldin: "Re: populate DropDownList from DB"
- Previous message: Viktor Popov: "Re: populate DropDownList from DB"
- In reply to: Ricardo Corsi: "How can i call a Trigger in ASP.NET ?"
- Next in thread: Thomas Dodds: "Re: How can i call a Trigger in ASP.NET ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
