SQL Unit Testing Advice Best Practices RRS feed

  • Question

  • Hello Community,

    Can someone please advise on the best methods to deploy for unit testing SQL queries. 

    I have read something about tSQLt, but I'm not sure what it entails. I will google it, but if someone could provide some advice guidance, that would be much appreciated.




    Friday, August 23, 2019 4:14 PM


  • Hi Carlton,


    Thank you for your issue.


    As far as I know, TSQLT is a third-party software. I don't recommend you use it. I'm not sure if it's going to go unpredictably wrong, and if it does, we won't be able to help solve the problem.


    Please refer to Getting Started with SQL Server Database Unit Testing in SSDT.


    Hope it will help you.


    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Monday, August 26, 2019 7:42 AM

All replies