SQL Server: Variables, Parameters or Literals? Or… Constants?

The age-old question “Should I use Variables, Parameters, or Literals in my code?” We’ve all seen the pros and cons for each of them and had to choose the option with the least negative impact. What if I told you there was a fourth option? For years, I wished SQL Server would support constants, a…

1