title: What is the Impact of compatibility level on stored procedures?
body: <p>I am currently using SSMS version 17.8.1
  The database that I am working with currently shows me the compatibility level of 110. I have various stored procedures running on this every day.
  Now to improve performance, I wanted to update my database's compatibility level to 140.
  I want to know if this would lead to any error with the current running of stored procs.</p>
  
  <p>I am still researching the negatives of updating compatibility level but have much clarity. I have looked at other similar questions on StackOverflow but I am specifically looking for answers in terms of the above specific version and compatibility levels</p>
  
  <p>My main aim is to gain performance by updating the compatibility level</p>