Using Golang to connect MSSQL under Windows

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Directory (?) [+]

1. Install the Microsoft SQL Server Native Client
2. Installing Golang's MSSQL Drive
3. Write test code

I wipe, recently down dozens of g of data (haha, you understand), are the MSSQL format, need to deal with. Want to use Golang processing, so you need Golang connection MSSQL.

1. Install the Microsoft SQL Server Native Client

Go to the official download bar:

[Plain]View Plaincopy print?

1. http://www.microsoft.com/zh-CN/download/details.aspx?id=35580

http://www.microsoft.com/zh-CN/download/details.aspx?id=35580

2. Install the Golang MSSQL Drive

Go get CODE.GOOGLE.COM/P/ODBC

3. Write the test code:

[Plain]View Plaincopy print?

2. Package Main
6. Import (
8. _ "Code.google.com/p/odbc"
10. "Database/sql"
12. "FMT"
14. )
18. Func Main () {
20. Conn, err: = SQL. Open ("ODBC", "Driver={sql server};server=192.168.1.1;port=1433;uid=sa;pwd=password;database=test")
24. If err! = Nil {
26. Fmt. PRINTLN ("Connecting Error")
28. Return
30. }
32. Defer Conn. Close ()
34. stmt, ERR: = conn. Prepare ("Select Top 5 ID from Users_role")
36. If err! = Nil {
38. Fmt. Println ("Query Error", err)
40. Return
42. }
44. Defer stmt. Close ()
46. Row, err: = stmt. Query ()
48. If err! = Nil {
50. Fmt. Println ("Query Error", err)
52. Return
54. }
56. Defer row. Close ()
58. For row. Next () {
60. var ID int
62. If err: = row. Scan (&id); Err = = Nil {
64. Fmt. PRINTLN (ID)
66. }
68. }
70. Fmt. Printf ("%s\n", "Finish")
72. Return
74. }

Using Golang to connect MSSQL under Windows