惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Security Latest
Security Latest
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Stack Overflow Blog
Stack Overflow Blog
WordPress大学
WordPress大学
N
Netflix TechBlog - Medium
GbyAI
GbyAI
云风的 BLOG
云风的 BLOG
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
宝玉的分享
宝玉的分享
博客园 - 【当耐特】
C
Cyber Attacks, Cyber Crime and Cyber Security
雷峰网
雷峰网
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
T
Threat Research - Cisco Blogs
NISL@THU
NISL@THU
Spread Privacy
Spread Privacy
P
Proofpoint News Feed
J
Java Code Geeks
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
MyScale Blog
MyScale Blog
T
Tor Project blog
P
Proofpoint News Feed
C
CERT Recently Published Vulnerability Notes
P
Privacy & Cybersecurity Law Blog
MongoDB | Blog
MongoDB | Blog
Simon Willison's Weblog
Simon Willison's Weblog
C
Cybersecurity and Infrastructure Security Agency CISA
L
LINUX DO - 热门话题
小众软件
小众软件
G
GRAHAM CLULEY
P
Privacy International News Feed
AWS News Blog
AWS News Blog
Know Your Adversary
Know Your Adversary
P
Palo Alto Networks Blog
人人都是产品经理
人人都是产品经理
S
Schneier on Security
Scott Helme
Scott Helme
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
B
Blog RSS Feed
T
The Exploit Database - CXSecurity.com
Recent Announcements
Recent Announcements
E
Exploit-DB.com RSS Feed
C
CXSECURITY Database RSS Feed - CXSecurity.com
U
Unit 42
The Register - Security
The Register - Security
S
Securelist
Martin Fowler
Martin Fowler
Project Zero
Project Zero
大猫的无限游戏
大猫的无限游戏
Cisco Talos Blog
Cisco Talos Blog

博客园 - 山顶洞外人

k8s部署dengine-3.3.6.9 wsl 磁盘 SQL 写法对比 关于达梦8管理工具执行多行sql语法错误问题 从C#接口的属性获取多个实现类中字段的值 idea 中无法连接 sql server 数据库,报错 [08S01] 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接 TransactionScope 图片扩容 已将此 订阅标记为不活动,必须将其重新初始化。需要删除NoSync 订阅,然后重新创建它们 visual studio 2017 将winform 打包成 msi 安装文件 漏洞处理 阿里云物联网测试 net core3.1 + electron 9.31.2 项目初始化 delete in 事故清表 webapi filter 分组后条件查询 一行拆多行 有关数据库锁表 order by 排序的数字异常
sql 脚本执行时间
山顶洞外人 · 2020-11-20 · via 博客园 - 山顶洞外人
SET STATISTICS PROFILE ON; 
SET STATISTICS IO ON; 
SET STATISTICS TIME ON; 
GO 
/*--你的SQL脚本开始*/
SELECT l2.num,l1.*
    FROM uvTaskList l1 ,
        ( SELECT WS_ID ,
                ROW_NUMBER() OVER ( ORDER BY WS_ID DESC ) AS num
            FROM uvTaskList
            WHERE ALLOWED_OPERATOR_CAL LIKE '%118%'
        ) l2
    WHERE l1.WS_ID = l2.WS_ID
        AND l2.num BETWEEN 61 AND 70;
GO 
/*--你的SQL脚本结束*/
SET STATISTICS PROFILE OFF; 
SET STATISTICS IO OFF; 
SET STATISTICS TIME OFF;
DECLARE @d DATETIME;
SET @d = GETDATE();
/*你的SQL脚本开始*/
SELECT l2.num,l1.*
    FROM uvTaskList l1 ,
        ( SELECT WS_ID,ROW_NUMBER () OVER (ORDER BY WS_ID DESC) AS num FROM uvTaskList
            --WHERE ALLOWED_OPERATOR_CAL LIKE '%118%'
        ) l2
    WHERE l1.WS_ID = l2.WS_ID
        AND l2.num BETWEEN 61 AND 70;
/*你的SQL脚本结束*/
SELECT [语句执行花费时间(毫秒)] = DATEDIFF(ms,@d,GETDATE());