SELECT CASE WHEN COALESCE(title2, title)='RUNTIME PARAMETER'
It is ok but I want them not to be written in the function because anyone developer can mess it up. There will be lot of queries which will get run time parameters also from functions.
I want it somewhere so that it is safe. But it should be available during run time, means if i want to replace a query the i should be able to so that without the need of building and deploying the files.
One way i was thinking is to use either resource files or config files but i cannot make mind. I don't want the performance to take a hit yet to maintain flexibility and maintainability.
Using resource files means to load read text which will incur some performance loss but is better than config files as they are not safe and easily readable.