the demo of github.com/denisenkom/go-mssqldb

testmssql.go

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/denisenkom/go-mssqldb"
)

func main() {
	DB, err := sql.Open("mssql", "server=172.16.32.1**;port=1433;user id=sa;password=*****;database=demo;")

	count := 5
	sql := fmt.Sprintf("select top %d id,name from demo", count)
	row, err := DB.Query(sql)
	defer row.Close()
	if err != nil {
		fmt.Println(err)
	} else {
		for row.Next() {
			var id int
			var name string
			row.Scan(&id, &name)
			fmt.Print(id)
			fmt.Println(name)
		}
	}
}