Category

Databases

33 articles in this category

How to get current MS SQL 2008 Version

December 27, 2011 1 min read

Here's a quick T-SQL to get you the current version of your SQL server. SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY ('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition…

VBScript Informix DSN Test Script

August 16, 2011 1 min read

So I have an Informix Dynamic Server (7) and I want to setup a Microsoft Windows ODBC system profile and then connect to it using VBScript. I will…

MySQL CLI Output Formatting Tips

March 10, 2009 1 min read

I’m sure you’ve seen results similar to this on a standard query: Now, if you use the \G option (Send command to mysql server, display result vertically.): That…