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

Question

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?

Answer 1

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...