Hi Experts ,My developer write below TSQL query and asked me to review it . what steps should i take ?and how i do i test it ?
You will need to sit down with the developer and understand the purpose of this script. What is the intention? The project requirement? If you understand those, you will know how you should review and approve it if you think the script is fine, or reject and send back for rework if there is a better way to go about the requirement.
Testing should be done first on a local/development environment and see its results. If passed, promote it to higher environments.
answered Feb 15 at 12:57 PM