Versioning of the Procedure

Asked

Viewed 51 times

1

I’m having a kind of conceptual doubt.

I am currently working on a project where I will have to check the calls of some api’s. For example:

Urls: /api/V1.0/Chamados/1220
      /api/V1.5/Chamados/1220

The difference between the two calls is that version 1.5 will return some more fields. Only the system uses Stored Procedures (and I don’t have the autonomy to change this condition... it has to be like this and end).

How would you make DO NOT CHANGE the precedent that meets version 1.0? Would it be the case to duplicate the precedent and add the fields? Does anyone know any kind of different approach?

sql-server stored-procedures

  • it is possible to execute another query and add to the final result along with the result of this process?

  • It would be interesting if you put a practical example of the way it currently works to give an idea of solutions

1 answer

0

Pass a parameter with the version for the trial and based on the informed version you make the data return.

Browser other questions tagged sql-server stored-procedures

You are not signed in. Login or sign up in order to post.