captncraig · September 22, 2014 17:29 · captncraig · Sep 22, 2014
diff --git a/create table b/create table
 CREATE TABLE [dbo].[Foobar](
 	[Foo] [int] NULL
 ) ON [PRIMARY]

 GO

diff --git a/sqltest.go b/sqltest.go
 package main

 import (
 	"database/sql"
 	"fmt"

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

 func main() {
 	db, err := sql.Open("mssql", "server=myserver;database=MyDb;")
 	if err != nil {
 		fmt.Println(err)
 		return
 	}
 	defer db.Close()
 	_, err = db.Query(`select top(1000) Foo,Bar from Foobar`)
 	if err != nil {
 		fmt.Println(err)
 		return
 	}
 }
	package main

	import (
	"database/sql"
	"fmt"

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

	func main() {
	db, err := sql.Open("mssql", "server=myserver;database=MyDb;")
	if err != nil {
	fmt.Println(err)
	return
	}
	defer db.Close()
	_, err = db.Query(`select top(1000) Foo,Bar from Foobar`)
	if err != nil {
	fmt.Println(err)
	return
	}
	}