Hi All..
Can someone help me with syntax on how to select a record from tableA(based on some criteria) and insert into tableB and then delete that record from tableA, all in one single statement in query analyzer. Do I use the memory resident DELETED table(can this even be used anywhere other than triggers) for this purpose and if so how?
THanx in advance....
Can someone help me with syntax on how to select a record from tableA(based on some criteria) and insert into tableB and then delete that record from tableA, all in one single statement in query analyzer. Do I use the memory resident DELETED table(can this even be used anywhere other than triggers) for this purpose and if so how?
THanx in advance....