tsqlt.org
AssertEmptyTable • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/assertions/assertemptytable
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. TSQLtAssertEmptyTable [@TableName = ] 'name of table to be checked' [, [@FailMsg = ] 'message' ]. Name of table to be checked. The name of a table which is expected to be empty. @Expected is NVARCHAR(MAX) with no default. Raises a ‘failure’ error if the table contains any rows. AssertEmptyTable checks if a table is empty. If the table does contain any rows, the failure message displays all rows found. Fake Table EXEC tSQL...
tsqlt.org
AssertNotEquals • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/assertions/assertnotequals
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. TSQLtAssertNotEquals [@expected = ] expected value , [@actual = ] actual value [, [@message = ] 'message' ]. The expected value for the test. @expected is SQL VARIANT with no default. The actual value resulting from processing during the test. @actual is SQL VARIANT with no default. Raises a ‘failure’ error if expected and actual are equal. This is the "NotEqual" test so the text should read:. Sponsors & Contributors.
tsqlt.org
User Guide • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. This reference contains an explanation of each of the public tables, views, stored procedures and functions provided by tSQLt. Test Creation and Execution. Is it possible to disable constraints on a faketable? By default, a fake table doesn't have any constraints. Also, just curious can the identity columns be set to a seed value? Currently it is not possible to run tests without the tSQLt transaction. However, you co...
nigelpsammy.com
T-SQL Tuesday #029 - Let's have a SQL Server 2012 party ~ Nigel Sammy - Blog
http://www.nigelpsammy.com/2012/04/t-sql-tuesday-029-lets-have-sql-server.html
T-SQL Tuesday #029 - Let's have a SQL Server 2012 party. Tuesday, April 03, 2012. It’s time for T-SQL Tuesday and this month I am hosting the party. I had another topic in mind when I asked to be a host but since the RTM occurred in March I thought it would be best to pick a topic focusing on SQL Server 2012! This month's topic is: What do you think is a useful feature of SQL Server 2012? Then be the blogger who wrote about a useful feature that no one else covered. Trackbacks should work, but if you don...
tsqlt.org
NewTestClass • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/test-creation-and-execution/newtestclass
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Test Creation and Execution. TSQLtNewTestClass [@ClassName = ] 'class name'. 8216;class name’. The name of the test class to be created. An error may be raised if the test class already exists and an object belonging to it cannot be dropped. Stored procedures in the test class schema are considered test cases if their name begins with ‘test’. Example: Creating a test class and test case. 8216;class name’. All test case st...
tsqlt.org
Test Creation and Execution • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/test-creation-and-execution
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Test Creation and Execution. Test Creation and Execution. This section describes how test cases are created and executed, and provides the reference pages for the various methods to manage and execute test cases. We’re going to answer two important questions in this section, “What happens when you create a test class? 8221; and “What happens when a test class gets executed? What happens when you create a test class? F The...
tsqlt.org
tSQLt Tutorial • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/tsqlt-tutorial
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Welcome to tSQLt, a unit testing framework for the T-SQL language for Microsoft SQL Server 2005 and beyond. tSQLt takes database unit testing a step further by providing methods to help isolate functionality to be tested. Before diving in to the isolation features, however, let’s start with a simple example. EXEC tSQLt.Run 'testFinancialApp';. Our test procedure calls the ConvertCurrency procedure (in the FinancialApp sch...
tsqlt.org
Assertions • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/assertions
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. This section contains the various assertion stored procedures which can be used to compare values. Also included is the Fail stored procedure which marks a test case as failed. TSQLt Snippets for SQL Prompt (2934 downloads). Sponsors & Contributors. Test Creation and Execution. TSQLt tag on stackoverflow.com. A sqlity.net llc.
tsqlt.org
Downloads • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/downloads
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Download the latest tSQLt version here:. Download “tSQLt” tSQLt V1.0.5873.27393.zip – Downloaded 6198 times – 86 kB. Older versions are available here. New Tool: SQL Cover. Check out Ed Elliott’s post about it here. The tSQLt source code is now officially hosted on GitHub! Get the source code together with all its tests here:. You can download the latest SQL Prompt snippets here:. Older versions are available here. I will...
tsqlt.org
RenameClass • tSQLt - Database Unit Testing for SQL Server
http://tsqlt.org/user-guide/test-creation-and-execution/renameclass
TSQLt - Database Unit Testing for SQL Server. Database Unit Testing for SQL Server. Test Creation and Execution. TSQLtRenameClass [@SchemaName = ] 'class name' , [@NewSchemaName = ] 'new class name'. 8216;class name’. The name of the class (schema) to be renamed. 8216;new class name’. The new name of the test class (schema). An error may be raised if an object on the test class cannot be transferred to the new test class. Example: Creating and then renaming a test class. Sponsors & Contributors.
SOCIAL ENGAGEMENT