随笔分类 -  sql

该文被密码保护。

该文被密码保护。

摘要：UPDATE COPTH SET TH026='Y' FROM COPTH LEFT JOIN COPTG ON TG001=TH001 AND TG002=TH002 WHERE TH026='N' AND TG003>='20130601' AND TG003<='20130630' AND TG001='2360' AND TG023='Y' AND TG002 NOT IN ('130629009','130625003','1306190 阅读全文

摘要：SQL 计算每个月的第一天，最后一天，本月的天数。sql server：--frist dayselect dateadd(dd,-datepart(dd,getdate())+1,getdate())--last dayselect dateadd(dd,-datepart(dd,getdate()) ,dateadd(mm,1,getdate()))--next month first dayselect dateadd(dd,-datepart(dd,getdate())+1,dateadd(mm,1,getdate()))--本月天数select datediff(dd,dateadd 阅读全文

该文被密码保护。

摘要：清除 易飞 DSCSYS库日志 SQL语句USE DSCSYSALTER DATABASE DSCSYS SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE DSCSYS SET RECOVERY SIMPLE DBCC SHRINKFILE (N'DSCSYS_Log' , 11, TRUNCATEONLY)ALTER DATABASE DSCSYS SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE DSCSYS SET RECOVERY FULL 阅读全文

该文被密码保护。