Category Archives: db

Test Database Connection SQL Query

Posted on July 1, 2015 by Jianming Li

Oracle SELECT sysdate FROM DUAL; DB2 SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1; SQL Server SELECT GETDATE() AS [CurrentDateTime]; Test with UDL File * Create an empty file with extension type of .udl * Double click UDL file * Enter SQL server … Continue reading →

Posted in db | Tagged | Leave a comment