Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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())
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement