8781973974

* DatabaseFunctionalTests - Microsoft Visual Studio

File Edit View Project Build Debug Team SQL Tools O -

Toolbox Server Explorer

Test Explorer

<V R: - B Search

OuickLaunch (Ctrl+Q)

P -

Debug - Any CPU

Architecture Test ► Start -

Analyze Window

I Marek Zukowicz

▼ 9 X SqlServerFunctionsTests.cs [Design] ■*> X SqlServerFunctionsTests.cs

d bo_u f nGetAccou nti ng E nd Da teTest

Test

+ X Rename...

tJ Streaming Video: Configure continuo ^w Run Ali I Run... ▼ I Playlist: Ali Tests

^A SqlServerFunctionsTests (2)

O dbo.ufnGetAccountingEndDateTest O dbo.ufnGetAccountingEndDateTes...

1    -- database unit test for dbo.ufnGetAccountingEndDate

2    DECLARE 0RC AS DATETIME;

3

4    SELECT 0RC - NULI;

5

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

7

8    SELECT 0RC AS RC;

9 10

100%

Test Conditions:

+ X

Solution Explorer

(2 I^T© - c &

Search Solution Explorer (Ctrl*;)

p -

P Properties ■ ■ References M Database Triggers G dbo

^ m Functions

53 ufnGetAccountingEndDate.sgl

Open

Open With...

View Codę

View in Object Explorer

ountingStartDate.sql

Create Unit Tests...

Scope to This

[f3 New Solution Explorer View Refactor

Exclude From Project

tactlnformation.sql

:umentStatusTextsql

JuctDealerPrice.sql

3uctListPrice.sql

rtuctStandardCost.sql

:haseOrderStatusText.sc

fsOrderStatusTextsql

:k.sql

)Zeros.sql

►

Execution Time

dbo ufnGetAccountingEndDateTestl		Name	Type	Value		Cut	Ctrl+X
		checksumCondition!	Data Checksum	ResuItSet is expected to have checkf	&	Copy	Ctrl+C
Source: SqlServerFunctionsTests.cs lin		executionTimeCondition1	Execution Time	The SQL script must execute faster t	X	Delete	Del
					o	Rename
Output					p	Properties	Alt+Enter

nGetAccountingStartC

Show output from:

Build

=E

1>......Build started: Project: SqlServerFunctionsTests, Configuration: Debug Any CPU......    ▲

1> SqlServerFunctionsTests -> D:\Tests\DataBaseTests\DataBaseFunctionalTests\SqlServerFunctionsTests\bin\Debug\SqlServerFunctionsl

Fuli Path □ SqlScrvcr ANSI Nulls Quoted Identifiers

e.sql File Properties

Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped

D:\Tests\DataBaseTests\C,

Project Default Project Default