数据库
都叫我华哥哥
这个人很懒,不知道说点啥
展开
-
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 · 3632 阅读 · 0 评论 -
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 · 477 阅读 · 0 评论 -
巧妙运用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 · 263 阅读 · 0 评论 -
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 · 433 阅读 · 0 评论