Home SQL server- delete row from table using Trigger
Reply: 0

SQL server- delete row from table using Trigger

user432
1#
user432 Published in July 18, 2018, 10:30 pm

I have a problem with SQL server, I need to create a trigger that works that way:

Every time when I insert information to tblNotInterested (Inside the table I have two columns "email1" and "email2"). The trigger needs to check if "email1" and "email2" already exists in a different table named tblListOf. If they exist I need to delete the row in which they were found.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.322556 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO