dongya4089 2017-07-20 07:52
浏览 218
已采纳

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

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 2017-07-20 09:27
    关注

    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...
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?