- 博客(5)
- 资源 (8)
- 收藏
- 关注
原创 sql server计算两个时间点的时间差
计算两个时间点的时间差select datediff(second,'2009-01-05 12:30:00','2009-01-10 12:59:00')SELECT CAST(CAST(datediff(second,'2009-01-05 12:30:00','2009-01-10 22:59:00') / (60*60*24) AS INT) AS VARCHAR) + '天' + CAST(CAST(datediff(second,'2009-01-05 12:30:00',...
2020-09-08 15:35:23 3575
原创 sql server 压缩数据库日志
清空日志USE [master]GOALTER DATABASE ecology_jw SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE ecology_jw SET RECOVERY SIMPLE --简单模式GOUSE ecology_jwGODBCC SHRINKFILE (N'ecology_Log' , 11, TRUNCATEONLY)GO--'这里的DNName_Log 如果不知道在sys.database_files里.
2020-09-08 15:34:00 456
原创 巧妙运用master..spt_values查询时间
with tbzs as( select distinct datepart(week,allday.dates) weekRange, dateadd(Day,1-(datepart(Weekday,allday.dates)+@@datefirst-1)%7,allday.dates) firstDay, dateadd(wk, datediff(wk,0,allday.dates), 6) endDay from ( select CONVER...
2020-09-08 15:32:47 259
原创 Sql server 去掉html标签函数
CREATE FUNCTION [dbo].[removehtml] (@str NVARCHAR(MAX))RETURNS NVARCHAR(MAX)ASBEGIN WHILE CHARINDEX('<', @str) > 0 BEGIN SET @str = STUFF(@str, CHARINDEX('<', @str), CHARINDEX('>', @str) - CHARINDEX('<', @str) + 1, '');...
2020-09-08 15:30:23 425
RedHat6.5配置yum.txt
2020-09-08
LinuxOpenSSH8.3p1补丁包20200908.zip
2020-09-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人