how to access scalar value returned from a sql query
I have used sql connector to write a query and I need scalar values to be returned so that I can use them in a switch case to put my logic.
As there is one method get table to access the data which is returned in table format from a query but if we want to access the scalar value , do we need to mention in sql properties return type as scalar and just execute the query and I will be able to use output parameter? or is there any other method to access that?
I cannot test database connection now so not able to see that.