Test Database Connection SQL Query

Posted on July 1, 2015 by Jianming Li

Oracle

SELECT sysdate FROM DUAL;

SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1;

SELECT GETDATE() AS [CurrentDateTime];

* Create an empty file with extension type of .udl
* Double click UDL file
* Enter SQL server connection info

This entry was posted in db and tagged test. Bookmark the permalink.