Friday, June 18, 2021

Using SSMS for unit testing

 Search SSMS in start menu

Select SQL Server Management Studio 18

Run it as administrator

Fill in the server name

Click on "Connect"

In the actionpane click on "New Query"

In the availabl databases, select AxDB

No you can write the SQL query for unit testing

EXAMPLE :

select * from BANKACCOUNTTRANS

where BANKACCOUNTTRANS.ACCOUNTID = 'AUB-BHD'

and BANKACCOUNTTRANS.TRANSDATE >= '12/1/2019'

and BANKACCOUNTTRANS.TRANSDATE <= '12/31/2020'