Skip to content

Instantly share code, notes, and snippets.

@cx20
cx20 / hello.sql
Created June 10, 2012 13:57
Hello, H2 Database World!
SELECT 'Hello, H2 Database World!' AS Message;
@cx20
cx20 / hello.sql
Created June 10, 2012 13:56
Hello, HSQLDB World!
SELECT 'Hello, HSQLDB World!' AS Message FROM (VALUES(0));
@cx20
cx20 / hello.sql
Created June 10, 2012 13:54
Hello, DB2 World!
SELECT 'Hello, DB2 World!' AS Message FROM SYSIBM.DUAL
@cx20
cx20 / hello.sql
Created June 10, 2012 13:53
Hello, Berkeley DB World!
SELECT 'Hello, Berkeley DB World!' AS Message;
@cx20
cx20 / hello.sql
Created June 10, 2012 13:50
Hello, Oracle Database World!
SELECT 'Hello, Oracle World!' AS MESSAGE FROM DUAL;
QUIT
@cx20
cx20 / Hello.vbs
Created June 10, 2012 13:49
Hello, ACE Database World! (VBScript + ADO + OLEDB + ACE)
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Hello.accdb"
Set rs = cn.Execute("SELECT 'Hello, ACE Database World!' AS Message")
WScript.Echo rs(0).Name
WScript.Echo "--------------------------"
WScript.Echo rs(0).Value
@cx20
cx20 / Hello.vbs
Created June 10, 2012 13:48
Hello, ACE Database World! (VBScript + DAO + ACE)
Set dbe = CreateObject("DAO.DBEngine.120")
Set db = dbe.OpenDatabase("Hello.accdb")
Set rs = db.OpenRecordset("SELECT 'Hello, ACE Database World!' AS Message")
WScript.Echo rs(0).Name
WScript.Echo "--------------------------"
WScript.Echo rs(0).Value
@cx20
cx20 / Hello.vbs
Created June 10, 2012 13:47
Hello, Jet Database World! (VBScript + ADO + OLEDB + Jet)
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Hello.mdb"
Set rs = cn.Execute("SELECT 'Hello, Jet Database World!' AS Message")
WScript.Echo rs(0).Name
WScript.Echo "--------------------------"
WScript.Echo rs(0).Value
@cx20
cx20 / Hello.vbs
Created June 10, 2012 13:46
Hello, Jet Database World! (VBScript + DAO + Jet)
Set dbe = CreateObject("DAO.DBEngine.36")
Set db = dbe.OpenDatabase("Hello.mdb")
Set rs = db.OpenRecordset("SELECT 'Hello, Jet Database World!' AS Message")
WScript.Echo rs(0).Name
WScript.Echo "--------------------------"
WScript.Echo rs(0).Value
@cx20
cx20 / hello.sql
Created June 10, 2012 13:44
Hello, SQL Server Compact World!
SELECT 'Hello, SQL Server Compact World!' AS Message
GO