DatabaseStratum / py-stratum-mssql

        cursor.close()

    # ------------------------------------------------------------------------------------------------------------------

    def execute_sp_row0(self, sql: str, *params) -> Optional[Dict[str, Any]]:

        """

        Executes a stored procedure that selects 0 or 1 row. Returns the selected row or None.

        :param str sql: The SQL call the the stored procedure.

        :param iterable params: The parameters for the stored procedure.

        :rtype: None|dict[str,*]

        """

        cursor = self.__conn.cursor(as_dict=True)

        cursor.execute(sql, params)

        rows = cursor.fetchall()

        cursor.close()

        n = len(rows)

        if n == 1:

            return rows[0]

        elif n == 0:

            return None

        else:

            raise ResultException('0 or 1', n, sql)

    # ------------------------------------------------------------------------------------------------------------------

    def execute_sp_row1(self, sql: str, *params) -> Dict[str, Any]:

        cursor.close()

    # ------------------------------------------------------------------------------------------------------------------

    def execute_row0(self, sql, *params) -> Optional[Dict[str, Any]]:

        """

        Executes a query that selects 0 or 1 row. Returns the selected row or None.

        :param str sql: The SQL statement.

        :param iterable params: The parameters.

        :rtype: None|dict[str,*]

        """

        cursor = self.__conn.cursor(as_dict=True)

        cursor.execute(sql, *params)

        rows = cursor.fetchall()

        cursor.close()

        n = len(rows)

        if n == 1:

            return rows[0]

        elif n == 0:

            return None

        else:

            raise ResultException('0 or 1', n, sql)

    # ------------------------------------------------------------------------------------------------------------------

    def execute_row1(self, sql: str, *params) -> Dict[str, Any]: