jung1975
asked on
Trigger SQL server 2008
I have two table
TableA
ID Date QAY/N
1 01/01/23 0
TableB
I would like to create a trigger if table QA/Y/N column change to 1
Then insert the row to Table B and delete the row from A
Look like beow.. How can I create a trigger to do this using SQL 2008?
TableA
TableB
ID Date QAY/N Ready
1 01/01/23 1
TableA
ID Date QAY/N
1 01/01/23 0
TableB
I would like to create a trigger if table QA/Y/N column change to 1
Then insert the row to Table B and delete the row from A
Look like beow.. How can I create a trigger to do this using SQL 2008?
TableA
TableB
ID Date QAY/N Ready
1 01/01/23 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.