Example: Return the Value of Query Row Limit for Current Session
Assuming the Query_row_limit permission for the current session is 50, the following query returns the value “50” in x:
SELECT x = DBMSINFO('query_row_limit') AS x;
Note: The DBMSINFO function allows other request_name values relating to other aspects of the current session. For details, see the DBMSINFO Function section of the SQL Language Guide.