Jump to content

Sql query help..

Sarvapindi

By Sarvapindi
in Discussions

 Share

Recommended Posts

Biskot2 LEGEND

Biskot2

Posted
Posted
8 hours ago, Sarvapindi said:

Sql experts randi va..oka qn

i have a table ..

Table A...   With 1000 records with columns below

id.   Name

this table will be updated everyday...so some records will be deleted or some new records will be inserted. I want to find what are the records thats r inserted and records that r deleted everyday...and load those into another table...

how to do

trigger on insert and trigger on delete than fetch that data, insert into another table 

last ke Jai balaya anu gattiga

Link to comment
Share on other sites
  • Replies 31
  • Created
  • Last Reply

Top Posters In This Topic

  • Sarvapindi

    7

  • soodhilodaaram

    4

  • Mr Mirchi

    2

  • dasari

    2

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

BetterThief
BetterThief

daily snapshot teesi data ni inko table lo pettu (Table B).. danito Table A data ni compare chesi neeku kavalsina table lo load cheyyi.   Once load done delete records from Table B and reloa

BetterThief
BetterThief

10ge.. avi kooda rakunte etla vayya..   Inka DDL kooda ivvu manale.

AndhraneedSCS
AndhraneedSCS

Write a trigger and convert the inserts and deletes into an insert into the different table.     

Spartan PRODUCER

Spartan

Posted
Posted
15 hours ago, Suhaas said:

This should work

Change “UPDATE” to “DELETE” in the above statement as per OP’s requirement 

yeah Delete should be used.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...