8781973977

* DatabaseFunctionalTests - Microsoft Visual Studio

File Edit View Project Build Debug Team SQL Tools

O -    8 ~ & y d*

Toolbox Server Explorer

Debug - Any CPU

Architecture Test ► Start -

Analyze Window Help

fr³ Quick Launch (Ctrl+Q)    P _ n

! Marek Zukowicz

TestExplorer    ~ ł X

SqlServerFunctionsTests.resx -*> X SqlServerFunctionsTests.cs (Design)    SqlServerFunctionsTests.cs

^ Solution Explorer

Search P -

0 Strings * Add Resource * X Remove Resource S • Access Modifier

No codę gen *

a r© - ó ^ ® p

—

Search Solution Explorer (Ctrl+;)

B: -

aj Streaming Video: Configure continuo ^w Run Ali I Run... ▼ I Playlist: Ali Tests ▼ ^A SqlServerFunctionsTests (12)

dbo_ufnGetAccounting E nd DateTest <£) dbo_ufnGetAccountingEndDateTes... ® dbo_ufnGetAccountingEndDateTes...

dbo_ufnGetAccountingStartDateTest (£) dbo_ufnGetDocumen <£) d bo_ufnGet Prod uct Dcl

O dbo_ufnGet Prod uct Lis O dbo.ufnGetProductSti 4^ dbo.ufnGetPurchased O dbo_ufnGetSalesOrde O dbo_ufnGetStockTest O dbo_ufnLeadingZeros

Show output from: Build

P-

Name    Value

checksumConditionl.Configuration    Press to configure

dbo_ufnGetAccountingEndDateTest_TestAction.SqlScripj -- database unit test for dbo_ufnGetAccountingEndDateTest1_TestAction.SqlScri| -- database unit test for dbo_ufnGetAccountingEndDateTest2_TestAction.SqlScri| -- database unit test for dbo_ufnGetAccountingStartDateTest_TestAction.SqlScrip -- database unit test for dbo_ufnGetDocumentStatusTextTest_TestAction.SqlScric -- database unit test for

tctioaSgIScript -- database unit test for

Run Selected Tests

Debug Selected Tests

Analyze Codę Coverage for Selected Tests

Profile Test

Group By	►
Add to Playlist	►
Select Ali	Ctrl ♦ A
Open Test	F12

Comment

-- database unit test for dbo.ufnGetProductListPrice DECLARE @RC AS MONEY, @ProductlD AS INT, @OrderDate AS DATETIME;

New Playlist SkalarFunkctions

LU

O,

getdateO;

SELECT @KC =

[d bo]. [ufnGetProduct ListPrice) (@ Proc <§>OrderDate);

SELECT @RC AS RC;

1> DatabaseFunctionalTests -> D:\Tests\DataBaseTests\DataBaseFunctionalTests\DatabaseFunctionalTests\bin\Debug\DatabaseFunctionalTests. 2> SqlServerFunctionsTests -> D:\Tests\DataBaseTests\DataBaseFunctionalTests\SqlServerFunctionsTests\bin\Debug\SqlServerFunctionsTests. .......... Build: 2 succeeded, 0 failed, 0 up-to-date, 0 skipped ----------

>    i_ HumanResources

>    ti Person

>    ŚŚ Production

>    tii Purchasing

>    Śt Sales

>    M Security

>    Śi Storage

53 ExtendedProperties.sql 53 FullTextlndexes.sql EJ SqlServerFunctionsTests

>    p Properties

>    ■ ■ References

app.config

>    c* SqlDatabaseSetup.cs

* 53 SqlServerFunctionsTests.cs

T SqlServerFunctionsTests.resx

>    c* UnitTest1.cs

Solution Explorer

Team Explorer

Properties

□ Resource

(Name)

Comment

Filename Persistence Type

(Name)

Name used to identify the resource in codę.

d bouf nGetProductLi f

Embedded in .resx System.String, mscorli ■