Connect

Ref

|Connect|jdbc:sqlserver://myhost\myinstance;user=myuser;password=mypassword;databaseName=mydbname|

Configuration file

• connection configuration file in the root folder

#DbFit connection properties
Connection-string=jdbc:sqlserver://localhost\sql2012;

• in a test

!|Connect using file|.\Connections.ini|

Query

Query Type:

• Query
• Ordered Query

Mutliple line. See issue:

# will not work because of the <
!|Query|!-
select case when sysdate < sysdate +1 then 'X' else 'Y' end as dummy
from dual 
where 1 < 2
-!|