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)
 Trigger For Update Based On Two Tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-21 : 11:07:54
Rishi Nayar writes "I want to write a Trigger for Update which checks for a field named UserId in Two Tables. If UserId already exists then it should display some sort of warning message & cancel the update, But the fields other than UserId should be Updated.
The Two Table have a unique Id key.
Please help me on this.
Thanks."
   

- Advertisement -