![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SqlServer
。。。
b330850038
这个作者很懒,什么都没留下…
展开
-
SQL资料备份资料
SELECT * INTO Bs_Relation20210224修改重复资料备份 FROM (select Bs_Relation.Card_id,Bs_Relation.BindingDate,Bs_User.* from Bs_Relation,Bs_User where Card_id in (select Card_id from Bs_Relation group by Card_id having count (Card_id) > 2) and Bs_Us...原创 2021-02-24 11:59:42 · 82 阅读 · 0 评论 -
SQL 查询最近执行语句
Select TOP 1000 ST.text AS '执行的SQL语句', QS.execution_count AS '执行次数', QS.total_elapsed_time AS '耗时', QS.total_logical_reads AS '逻辑读取次数', QS.total_logical_writes AS '逻辑写入次数', QS.total_physical_reads AS '物理读取次数',...原创 2020-12-25 09:39:42 · 268 阅读 · 0 评论