SWAMY YT

SWAMY YT

  • 1.1k
  • 643
  • 30.1k

Exploring and understanding more in DB Indexing

Apr 24 2020 7:14 AM
Hello everyOne,
Actually i have a scenario that 
1) I am saving the data into the table (let say table name SaveTable) using MVC.net entityFramework,
in the mean Time i need to add the same data row into another table which is exist in the same DataBase (Let say DataTable Name SaveTable1) without coding in backend is it possible to do by making use of SQL triggers or any other options in management Studio.
2) I want to sort (like delete) the table data( SaveTable1) should keep the data for the past 2 month's only beyond that time the data in the table should be deleted 
3) How to do DataBase indexing on 2 columns in the table  (SaveTable1)
 
Any help appreciated 
Thanking You 

Answers (1)