SQL Unit Testing Advice Best Practices

Transact-SQL
1

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.

Cheers

Carlton

2

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

3

Hi

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

Anyhow
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
4

Thanks for reaching out Harishgg1