Deepak Ratan

Deepak Ratan

  • NA
  • 175
  • 50.9k

How write a single Triggers for INSERT, UPDATE, DELETE

Jun 18 2015 12:16 PM
HI all,
 
I am using SQL Server 2012.

I Need to create a Single Trigger From First_DataBase TableA to Second_DataBase TableB

When ever any modification done on TableA it'll affect the TableB

In this concept i am using Two DataBase

Whenever a row is inserted or updated or deleted in Table A, it should be affect the Table B.

Same Columns Name for TableA and TableB

How to handle this from a single trigger?

 
 

In this concept DataBaseA having 40 tables, Just i am creating a New Database as DataBaseB, I am going to copy all the 40 tables from DataBaseA to DataBaseB and i am renaming the 40 Tables, After that i am going to Use Trigger Concept for INSERT\UPDATE\DELETE, and Whenever a row is inserted or updated or deleted in Table A (DataBaseA) , it should be affect the Table B(DataBaseB) ...... Any body having Idea how to do this?


Answers (1)