随笔分类 -  Sql Server

SQL Server 杂项
摘要：数据库清除日志 1 --2005 2 DUMP TRANSACTION [DataBaseName] WITH NO_LOG 3 BACKUP LOG [DataBaseName] WITH NO_LOG 4 DBCC SHRINKDATABASE([DataBaseName]) 5 6 --201 阅读全文
posted @ 2022-01-13 16:46 yyutudou 阅读(59) 评论(0) 推荐(0)
sql server 分组
摘要：分组筛选第一条 SELECT * from( SELECT *, row_number () OVER ( partition BY [分组列] ORDER BY [排序列] DESC ) rowid FROM [table] WHERE 1=1 ) t WHERE rowid = 1; 分组后删除 阅读全文
posted @ 2022-01-13 15:29 yyutudou 阅读(186) 评论(0) 推荐(0)