8781973972

File Edit View Project Build Debug Team SQL Tools Architecture Test Analyze Window Help O -    Ul J* | 9 - C* - I Debug - Any CPU    - ► Start - I

K »Sl Ił = fi fi

! Marek 2ukowicz

Toolbox Server Explorer

Test Explorer

|J= - 5 Search

▼ ł X SqlServerFunctionsTests.resx    SqlServerFunctionsTests.cs [Design] * X SqlServerFunctionsTests.cs

^w Solution Explorer

P-

d bo.ufnGetAccou nti ngE nd DateT est

v Test

^v + X Rename..

tJ Streaming Video: Configure continuo Run Ali I Run... ▼ I Playlist: Ali Tests P SqlScrverFunctionsTests (2)

1    -- database unit test for dbo.ufnGetAccountingEndDate

2    DECLARE £RC AS DATETIME;

3

4    SELECT 0RC - NULL;

5

6    SELECT @RC [dbo].[ufnGetAccountingEndDate]();

7

8    SELECT 0RC AS RC;

9

10

(fi ^tO’Ói^® <>/»--

Search Solution Explorer (Ctrl■*•;)

Notifications

100% -

Test Conditions:

>    i HumanResources

>    Śi Person

>    Śt Production

>    tii Purchasing

>    M Sales

P Śi Security

>    śi Storage

51 ExtendedProperties.sql 51 FullTextlndexes.sql E3 Sq I ServerFunctionsTests P p Properties P ■ ■ References £) app.config

>    c» Sql DatabaseSetup.es

a [UD SqlServerFunctionsTests.cs

l3 SqlServerFunctionsTests.resx

Execution Time

+ X

dbo_ufnGetAccountingEndDateTest1

Source: SqlServerFunctionsTests.cs lir

| Name    Type

executionTimeCondition1    Execution Time

Value

The SQL script must execute faster than 00:00:30.

checksumCondition!    Data Checksum    The expected checksum needs to be configured.

Show output from: Build

li I

U &

J^UCl VCI l UIIV. C XUI i a l C3 V. 3 ” ✓ LS . \ I CO l ^ \i/a 10U03C IC313 \L/0 lOua 3CI UUdlUUOl ■ C3 O    V Cl I UlIWllUiO IC313 \UAU \UCUU^    V C l l Ul IW V. JkVSI • 3 IC3L3.

....... Build: 2 succeeded, 0 failed, 0 up-to-date, 0 skipped ----------

Solution Explorer

Properties    ^T f X

checksumCondition 1 MicrosoftData.Tools.Schema.J -

:!!+ p

|B Test Condition

(Name)    checksumCondition

_] Press to configure

Enabled    True