How to write triggers in stored procedure

[Sophia Rekhi]

Hi all, i want to know that "how to write triggers in stored procedures" is it possible? and can we write cursors in stored procedures? if yes then pls send me solution. Thanks

[vimal_yet]

declare cursor for open cursor_name while @@fetch_status=0 begin fetch next from cursor_name into variable_name1,var2......varn end If U Get Errors U Will Learn If U Don't Get Errors U Have Learnt

[Colin Angus Mackay]

Sophia Rekhi wrote:

i want to know that "how to write triggers in stored procedures" is it possible?

A trigger is a stored procedure of sorts that is run automatically on an event, such as data being inserted into a table. I don't understand the benefit of writing one in a stored procedure? I also doubt if it is possible. You could write some dynamic SQL and execute that in order to create a trigger from within a stored procedure, but wouldn't it be better just to write the trigger and be done with it?

---

Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website