dongya4089
dongya4089
2017-07-20 07:52

sqlx + Go:存储过程中的输出参数

  • IT行业问题
  • 计算机技术
  • it技术
  • 编程语言问答
  • 互联网问答
已采纳

I have mssql stored procedure that contains output parameter and can be called like this

EXEC [SP_NAME]
    @Input = N'Some Text',
    @Result = @Result OUTPUT

Do you know if it's possible to access this @Result in jmoiron/sqlx after sp call?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • douxiong2999 douxiong2999 4年前

    sqlx is just a wrapper around database/sql package. The query you're trying to perform is driver specific. Thus, it depends on the driver you're using to connect to the MSSQL server. If you're using https://github.com/denisenkom/go-mssqldb, based on issue #78, you can try the following:

    rows, err := db.Queryx(`EXEC [SP_NAME] @Input, @Result OUTPUT; 
              SELECT Result = @Result;`, sql.Named("Input", "Some Text"))
    //do something with rows...
    
    点赞 评论 复制链接分享

为你推荐