使用go来连接sql server数据库

go-mssql-using-go-mssqldb

package main

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

	_ "github.com/denisenkom/go-mssqldb"
)

func main() {

	connString := fmt.Sprintf("server=%s;user id=%s;password=%s;database=%s;encrypt=disable",
		"xx.xx.xx.xx", "xxx", "xxx", "xxxxx")

	conn, err := sql.Open("mssql", connString)
	if err != nil {
		log.Fatal("Open connection failed:", err.Error())
	}

	stmt, err := conn.Prepare(`select top 1 * from Users where UserName = 'xxx'`)
	if err != nil {
		log.Printf("\nPrepare failed:%T %+v\n", err, err)

	}
	//defer stmt.Close()

	row := stmt.QueryRow()
	var somenumber int64
	var somechars string
	err = row.Scan(&somenumber, &somechars)
	if err != nil {
		log.Fatal("Scan failed:", err.Error())
	}
}