Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can add test conditions to a SQL Server unit test by using the SQL Server Unit Test Designer. When you save the test class, the test conditions are automatically saved in your test project as C# or Visual Basic code in the source-code file containing the test class. After you save a test condition, you can edit it either in the SQL Server Unit Test Designer or in its source-code file.
Add test conditions to a SQL Server unit test
Open a SQL Server unit test in the SQL Server Unit Test Designer.
The name of the test you opened is displayed in the navigation bar at the top of the SQL Server Unit Test Designer. By using the navigation bar, you can select the different test methods that are in your test class.
In the navigation bar, select the test method to which you want to add test conditions, or select Common Scripts.
Common scripts don't belong to a particular unit test. Rather, they precede or follow unit tests in the test class. For more information, see Scripts in SQL Server Unit Tests.
In the navigation bar, select the Transact-SQL script to which you want to add test conditions. You can add test conditions to the pre-test, test, or post-test script.
The Transact-SQL script for that test appears in the Transact-SQL editor and its test conditions appear in the Test Conditions pane.
In the Test Conditions selection list, select a test condition and then select Add Test Condition (+).
The test condition is added to the unit test method.
You can reorder test conditions within a test method by selecting a test condition and then selecting the up and down arrows in the Test Conditions pane.
Select the test condition you just added and view the Properties window.
Configure the test condition in the Properties window. For example, you can change the Execution Time property of an Execution Time test condition. If you set this property, you cause your test to fail if the Transact-SQL script doesn't execute within the time that you specified.
Related content
- Create and define SQL Server unit tests
- How to: Create an Empty SQL Server Unit Test
- How to: Create SQL Server Unit Tests for Functions, Triggers, and Stored Procedures
- Use test conditions in SQL Server unit tests
- Scripts in SQL Server Unit Tests
- Interpret SQL Server unit test results
- How to: Run SQL Server unit tests