Topic: Whether it is possible to change the content of many scripts in a database?
There is a table in which scripts for an output of reports in FastReport are stored and in them for an age output is used "datediff (dd, birthdate, getdate ())/365.25". In this connection at some people the age settles up inaccurately.
These scripts are stored in the table in normal varchar (max) a format, and them there under 300 pieces. Whether it is possible all available scripts, replacing there this line, with for example such:
"(datediff (year, birthdate, getdate ()) -
when month (birthdate) <month (getdate ())
when month (birthdate)> month (getdate ())
when day (birthdate)> day (getdate ())
Such function the age settles up precisely, to the day.