Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Triggers in SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-17 : 08:00:35
Sonika writes "How to pass values from asp page to trigger in sql2000?
For example i want to insert the IP address & username of the person in one table as soon as some data is inserted in other table from ASP Page."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-17 : 08:02:44
You can't pass values to a trigger, but you can:

- insert values into a table that the trigger can access
- have the trigger call a stored procedure to do the work, and pass those values to the stored procedure
Go to Top of Page
   

- Advertisement -