SQL
慢慢非
顶顶顶顶顶点顶顶顶顶顶顶顶顶顶顶额达到顶顶顶顶顶点顶顶顶顶顶顶顶顶顶顶鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅
展开
-
sql 中延迟执行
sql 中延迟执行USE [CNPC_GasDataReport]GO/****** Object: StoredProcedure [dbo].[db_News_Info] Script Date: 04/23/2021 10:06:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--创建存储过程ALTER procedure [dbo].[db_News_Info]@CategoryID varchar(20),...原创 2021-04-23 10:40:15 · 1950 阅读 · 0 评论 -
按日期获取月的第几周--学习的忘了出处
SELECT [Time], CONVERT(varchar, YEAR([Time])) +'年'+CONVERT(varchar, month([Time])) +'月第'+CONVERT(varchar,datepart(d,[Time])/7 + (case when datepart(d,[Time])%7>datepart(weekday,[Time])then 2when (datepart(d,[Time])%7 = 0 and datep...原创 2020-12-10 14:57:25 · 101 阅读 · 0 评论 -
sql 加一条虚拟数据
select * from ( SELECT [ID] ,date ,year([Date] ) as year ,[Production] ,[ArtificialOil] FROM [dbo].[Sys_NationalCrudeOil] unio...原创 2018-08-17 08:28:05 · 1504 阅读 · 0 评论