title: Call stored procedure on Microsoft SQL Server using ODBC driver
body: <p>I have a stored procedure let the name be "vijaystoredprocedure" , if it is some query in mssql then i will query in Go like </p>
  
  <pre><code>l_query_str = fmt.Sprintf(`select * from Users where Fname='%s'`, l_firstanme)
  
  row, err := DBC.Query(l_query_str)
      if err != nil {
          log.Fatal("Prepare failed:", err.Error())
      }
  
      _, rows, r_err := DBScan_fn(row)
  
      if r_err != nil {
          fmt.Println("no data found err")
          return
      }
  </code></pre>
  
  <p>now since i have to get values from a stored procedure...can some one suggest how to acheive this in go</p>