SQL Test forum

SQL Test is a graphical unit test runner tool for SQL Server. It is integrated into SQL Server Management Studio and is powered by the free open source tSQLt unit testing framework. Please post new feature ideas here. For general questions and discussion, please use www.stackoverflow.com or ask.sqlservercentral.com with sql-server and tdd tags.

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the “My feedback” filter and select “My open ideas”.
(thinking…)
Reset

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
    1. Make Check More Visible

      I just started testing the product and one thing that is an annoyance for me is that when you run a test, the blue for selected row drowns out the check mark. This makes it hard to see when the task is actually finished. Perhas excluding that cell from being highlighted row would be the easiest fix.

      1 vote
      Vote 0 votes Vote Vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service

        You'll receive a confirmation email with a link to create a password (optional).

        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • Can you provide a right click menu option for scripting out all (or individual) tests

        Context menu option on all nodes in the SQL Test panel - with the following options:
        a. on the db node - "Script all tests" (scripts every test, and all classes)
        b. on a test class node - "Script all tests" (scripts all tests that belong to that class, and the class)
        c. on an individual test - "Script test"

        1 vote
        Vote 0 votes Vote Vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service

          You'll receive a confirmation email with a link to create a password (optional).

          Signed in as (Sign out)
          You have left! (?) (thinking…)
        • Can you explain or add the ability to install SQL Tests on a newly created database using commandline?

          More looking for an answer to this problem (trying to automate the install of SQL Tests on a newly created database using Team City.

          If it doesn't exist then can it be added?

          1 vote
          Vote 0 votes Vote Vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service

            You'll receive a confirmation email with a link to create a password (optional).

            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • Can you support TST as well? (tst.codeplex.com)

            TST is another open source framework for Unit testing sql server stored procedures. It would be great if the test runner supported this framework as well.

            3 votes
            Vote 0 votes Vote Vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service

              You'll receive a confirmation email with a link to create a password (optional).

              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • Have the SQL Test Window stay docked when I reopen SSMS.

              I docked my TEST window in the bottom right left hand corner, under my Object Explorer. But each time I reopen SSMS, it is floating again. One time it was almost completely off the screen to the left. Can you please have it stay docked?

              3 votes
              Vote 0 votes Vote Vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service

                You'll receive a confirmation email with a link to create a password (optional).

                Signed in as (Sign out)
                You have left! (?) (thinking…)
              • Give better access to setup routines for test classes

                tSQLt allows you to have class-specific set up SPs (called setup in the class schema). However I can't find an option to create these directly within SSMS. Perhaps a right click on the class to allow you to edit / create a setup script, as well as some way of visualising that a setup script exists for a given class within the SQL Test window.

                2 votes
                Vote 0 votes Vote Vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service

                  You'll receive a confirmation email with a link to create a password (optional).

                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • Refreshing should not change expansion/collapse status of tree nodes

                  When you refresh the tree all nodes are expanded. This is very frustrating when you have many test schemas and tests. Ideally a refresh should do the following:
                  1) Not change whether a node is expanded or collapsed
                  2) Apply to the node at which the refresh was done. If I select refresh from the context menu for a class then it should only refresh that node

                  3 votes
                  Vote 0 votes Vote Vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service

                    You'll receive a confirmation email with a link to create a password (optional).

                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • Keyboard short cut to run test or refresh

                    EXEC tSQLt.RunAll; -- ctrl-0 doesnt refresh the visual UI

                    1 vote
                    Vote 0 votes Vote Vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service

                      You'll receive a confirmation email with a link to create a password (optional).

                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • Code coverage

                      I would assume this to be non-trivial, but in learning about testing with application code, I find code coverage tools invaluable.

                      14 votes
                      Vote 0 votes Vote Vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service

                        You'll receive a confirmation email with a link to create a password (optional).

                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                      • Close Messages on escape

                        When your tests fail you should be able to close the window using escape key

                        2 votes
                        Vote 0 votes Vote Vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service

                          You'll receive a confirmation email with a link to create a password (optional).

                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • Needs better transaction handling

                          I have a test for a stored procedure with a try/catch that rolls back a transaction, using a proper transaction save point and evaluating XACT_STATE() before rolling back (http://msdn.microsoft.com/en-us/library/ms188378.aspx). For negative testing, I created a trigger on a table to prevent an update. When I run the stored procedure nested inside of a transaction, it works fine. When I run my test stored procedure manually, it runs fine. But when I run from the SQL Test panel, I get this error:

                          Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1,… more

                          1 vote
                          Vote 0 votes Vote Vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service

                            You'll receive a confirmation email with a link to create a password (optional).

                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • test order

                            It appears that there may be something wrong with the test ordering in SQL Test. I have about 50 tests in my current db project split into about 5 TestClasses. For some reason the tests under one of the schema's are not ordered alphabetically. I have check the tSQLt tests view and my tests order correctly in the view. Any ideas why this might be happening

                            3 votes
                            Vote 0 votes Vote Vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service

                              You'll receive a confirmation email with a link to create a password (optional).

                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                            • Test count per Test Class

                              It would be helpful to have a test count per test class and total test count. It would also be nice to have a count of tests passed and tests failed.

                              1 vote
                              Vote 0 votes Vote Vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service

                                You'll receive a confirmation email with a link to create a password (optional).

                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                              • SqlCop.test Decimal Size Problem Doesn't like spaces

                                This test failed for objects which had decimals defined as decimal ( 3, 5) Note the spaces.

                                3 votes
                                Vote 0 votes Vote Vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service

                                  You'll receive a confirmation email with a link to create a password (optional).

                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • Remove Test Class

                                  Currently it is not possible to remove a test class (and all tests associated with the test class) via the SQL Test interface. This would be another nice to have / productivity feature

                                  2 votes
                                  Vote 0 votes Vote Vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service

                                    You'll receive a confirmation email with a link to create a password (optional).

                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    started  ·  0 comments  ·  Admin →
                                  • Ability to rename tests and testclasses

                                    It would be really helpful to be able to rename a test or the testclass from the test context menu

                                    4 votes
                                    Vote 0 votes Vote Vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service

                                      You'll receive a confirmation email with a link to create a password (optional).

                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                    • recognise which databases have tests in them

                                      When I restore a database - either from backup or source control - tests are not shown automatically in the SQLTest window. By adding the database to SQLTest it shows the authored test, but it would be helpful if this process was automatic. This would be particularly helpful in multi-developer projects where tests are not necessarily written by the same person.

                                      4 votes
                                      Vote 0 votes Vote Vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service

                                        You'll receive a confirmation email with a link to create a password (optional).

                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                      • The @@identity test does not take the phrase @@identity

                                        The @@identity test also takes the phrase @@identity into account when it exists in comments. I have some procedures that already have this changed, but a changelog comment inside the code also raises this error.

                                        1 vote
                                        Vote 0 votes Vote Vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service

                                          You'll receive a confirmation email with a link to create a password (optional).

                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                        • How do you Apply the IDENTITY constraint to a FakeTable column?

                                          I want to test a proc that adds a record to a table. If I create an empty fakeTable and add a record to it I would expect it to have a value in the "ID" filed according to the IDENTITY(x,y) constraint of the field. It appears FakeTable drops that constraing. Is there a way to add it. I'm not sure the "name" of that constraint in order to use it in a call to tSQLt.Applyconstraint.

                                          1 vote
                                          Vote 0 votes Vote Vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service

                                            You'll receive a confirmation email with a link to create a password (optional).

                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                          • 3 votes
                                            Vote 0 votes Vote Vote
                                            Vote
                                            Sign in
                                            Check!
                                            (thinking…)
                                            Reset
                                            or sign in with
                                            • facebook
                                            • google
                                              Password icon
                                              I agree to the terms of service

                                              You'll receive a confirmation email with a link to create a password (optional).

                                              Signed in as (Sign out)
                                              You have left! (?) (thinking…)
                                            ← Previous 1 3
                                          • Don’t see your idea?
                                          • Post a new idea…
                                          • SQL Test forum

                                            Knowledge Base and Helpdesk