2022-05-15 16:03:16

查看逻辑读前10的SQL：复制代码 代码如下:set linesize 300;set pagesize 300;set long 50000;SELECT *FROM (    SELECT sql_fulltext AS sql, SQL_ID,buffer_gets / executi

2022-05-15 15:59:16

Oracle的show processlist复制代码 代码如下:set linesize 400;set pagesize 400;col sql_text format a100;col machine format a25;col username format a15;SELECT a.use

2022-05-10 20:21:49

复制代码 代码如下: ALTER PROCEDURE [a0919194122].[dnt_getappinvitelist] @uid int, @pageindex int, @pagesize int AS DECLARE @startRow int, @endRow int SET @start

2022-05-08 19:36:14

复制代码 代码如下:declare @PageNumber int declare @PageSize int set @PageNumber=2 set @PageSize=20 --利用between select * from ( select row_number() over (order