SELECT * FROM tablename
DROP TABLE #info
CREATE TABLE #info(
ID INT,
TimeDifPerMiniSeconds INT,
DataNum INT
)
DECLARE @timeStart DATETIME ,
@timeEnd DATETIME ,
@maxnum INT = ( SELECT MAX(序号)
FROM tablename
) ,
@num INT= 1 ,
@ExecSql NVARCHAR(MAX),
@DataNum INT
WHILE @num <= @maxnum
BEGIN
SET @ExecSql = ( SELECT 测试脚本
FROM tablename
WHERE 序号 = @num
)
PRINT @ExecSql
SET @timeStart = GETDATE()
EXEC (@execsql)
SET @DataNum=@@ROWCOUNT
SET @timeEnd = GETDATE()
INSERT INTO #info
SELECT @num ,
DATEDIFF(millisecond, @timeStart, @timeEnd),@DataNum
SET @num=@num+1
END
SELECT A.*,B.* FROM tablename A INNER JOIN #info B ON A.序号=B.ID ORDER BY A.序号
DROP TABLE #info
CREATE TABLE #info(
ID INT,
TimeDifPerMiniSeconds INT,
DataNum INT
)
DECLARE @timeStart DATETIME ,
@timeEnd DATETIME ,
@maxnum INT = ( SELECT MAX(序号)
FROM tablename
) ,
@num INT= 1 ,
@ExecSql NVARCHAR(MAX),
@DataNum INT
WHILE @num <= @maxnum
BEGIN
SET @ExecSql = ( SELECT 测试脚本
FROM tablename
WHERE 序号 = @num
)
PRINT @ExecSql
SET @timeStart = GETDATE()
EXEC (@execsql)
SET @DataNum=@@ROWCOUNT
SET @timeEnd = GETDATE()
INSERT INTO #info
SELECT @num ,
DATEDIFF(millisecond, @timeStart, @timeEnd),@DataNum
SET @num=@num+1
END
SELECT A.*,B.* FROM tablename A INNER JOIN #info B ON A.序号=B.ID ORDER BY A.序号