SQL Unit Testing Advice Best Practices

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.



I'm very surprised I'm not getting any feedback on this question. ......


There could be several reasons why you are not getting feedback
None of which ..may cross your mind

When i did unit testing one thing that comes to mind is
Using one id
Select *from table where id = 34
Hope this helps :slightly_smiling_face::slightly_smiling_face:

1 Like

Thanks for reaching out Harishgg1