row level triggers
I have a table with 10 columns. I want to write a row level trigger that
will trigger whenever a row is inserted into my table. This trigger will
then take the values of the 10 columns and pass it to a procedure.
how can i code that?
also, if two rows are inserted almost at the same time, what is the best
way so that my trigger takes both rows and pass them to my procedure instead
of calling my procedure twice(one for each row inserted).
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL