update are synchronized in 6 hours format and using index also smells good to taste

yeah planned about same one thanks but could you please provide me a query as i am a beginner in sql server

if any insertions are done then the inserted data and modified id should be automatically generated in master table

ya thanks for that

🙂

in the above i mentioned,

the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......