In short, I’m going to look at an efficient way to just identify differences and produce some helpful statistics along with them. So, how can you easily do that in SQL Server? In other words, you need to be sure that anything that was supposed to change, did, and that anything else remains the same. Whatever the case, you want to be sure that whatever changes have been made (whether in your code or somewhere else), the changes in the output are as expected. Now, you’re asked to change something, or perhaps you find out your existing code will have to work with new source data or maybe there’s a performance problem and you need to tune the query. If you’ve been developing in SQL Server for any length of time, you’ve no doubt hit this scenario: You have an existing, working query that produces results your customers or business owners say are correct.
0 Comments
Leave a Reply. |