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

推荐订阅源

Blog — PlanetScale
Blog — PlanetScale
博客园_首页
WordPress大学
WordPress大学
博客园 - 聂微东
P
Privacy International News Feed
Forbes - Security
Forbes - Security
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
Last Week in AI
Last Week in AI
C
CERT Recently Published Vulnerability Notes
月光博客
月光博客
NISL@THU
NISL@THU
美团技术团队
T
Tailwind CSS Blog
Jina AI
Jina AI
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
Apple Machine Learning Research
Apple Machine Learning Research
C
Cisco Blogs
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
The Hacker News
The Hacker News
B
Blog
P
Palo Alto Networks Blog
L
Lohrmann on Cybersecurity
有赞技术团队
有赞技术团队
The Register - Security
The Register - Security
S
Securelist
A
Arctic Wolf
MyScale Blog
MyScale Blog
H
Help Net Security
N
Netflix TechBlog - Medium
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
T
Threatpost
Recent Commits to openclaw:main
Recent Commits to openclaw:main
Security Latest
Security Latest
T
Tor Project blog
V
Vulnerabilities – Threatpost
V
V2EX
AI
AI
Hugging Face - Blog
Hugging Face - Blog
大猫的无限游戏
大猫的无限游戏
博客园 - Franky
Simon Willison's Weblog
Simon Willison's Weblog
小众软件
小众软件
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
H
Hackread – Cybersecurity News, Data Breaches, AI and More
T
Troy Hunt's Blog
Schneier on Security
Schneier on Security
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
H
Heimdal Security Blog
Google Online Security Blog
Google Online Security Blog
Know Your Adversary
Know Your Adversary

博客园 - 山顶洞外人

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());