db.go

package main

import (
	"database/sql"
	"fmt"
	"log"

	// this is the driver & yes, even though we're throwing 
	// it away to `_`, it's still needed
	_ "github.com/denisenkom/go-mssqldb"
)

var (
	db     *sql.DB
	server = "localhost"
	// Yes, I hate this too...
	port   = 60515
)

func main() {
	// Build connection string
	connString := fmt.Sprintf(
		"server=%s;port=%d;Trusted_Connection=True;AppName='Golang'",
		server,
		port,
	)

	// I want the line that the error occurs in my logs, please & thank you
	log.SetFlags(log.Lshortfile)

	// Create connection pool
	var err error
	db, err = sql.Open("sqlserver", connString)
	if err != nil {
		log.Fatalln("Creating connection pool failed:", err.Error())
	}

	stringDate, err := getDate()
	if err != nil {
		log.Fatalln("getDate() failed:", err.Error())
	}
  
	fmt.Println("Read:", stringDate)
	fmt.Println("Read rows successfully!")
	fmt.Println("Finished.")
}

func getDate() (string, error) {
	var dte string

	// We're "scanning" the values from the query into the `dte`
	// variable using `&<var name>`. Different, but interesting...
	if err := db.QueryRow("SELECT dt = SYSDATETIME();").Scan(&dte); err != nil {
		return "false", fmt.Errorf("getDate() function failed! %s", err.Error())
	}

	return dte, nil
}