Red Gate has released SQL Test, a unit testing add-in for SQL Server Management Studio. It allows developers to create and run unit tests from within SSMS, and share them with other team members.

tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected ...

With a few tweaks, you can turn Visual Studio's basic unit-testing capabilities into a powerful and extensible tool for improving code quality.

To work with NUnit you would need to install the NUnit unit testing framework through NuGet package manager in your Visual Studio IDE.