About
List of DbFit instructions.
Articles Related
Instructions
Connect
|Connect|jdbc:sqlserver://myhost\myinstance;user=myuser;password=mypassword;databaseName=mydbname|
- 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
-!|