All test case names must start with 'test' and follow SQL Server stored procedure naming conventions. This example creates a test table, inserts values, and calls the function GetStatusMessage.

Unit-testing should have as few barriers as possible. For relational databases those barriers range from external dependencies to speed to keeping the relational schema synchronized with your object ...

The database schema will update and change during the lifetime of the application. When these changes are developed, the schema of environments like DEV, INT and TST will differ from the PROD schema.