Updating sal dynamically in sql server.

Question

Hai friends,

 

Please provide the solution for the following:

 

In an employee table 10 employees are there, every month we have to increase the salary 1000 for all the employees  dynamically.

 

I don't want to write query every month.

 

Based on the date Employee joined, It should update.

 

Please provide solution friends.