代码搜索：datediff
找到约 324 项符合「datediff」的源代码
代码结果 324
www.eeworm.com/read/124241/14584661
sql valid.sql
USE Stock
GO
CREATE VIEW dbo.Valid
AS
SELECT dbo.ProInStore.SpId AS 库存记录编号, dbo.Product.Pname AS 产品名称,
dbo.ProInStore.Pprice AS 产品价格, dbo.ProInStore.Pnum AS 产品数量,
dbo.ProInStore.Ma
www.eeworm.com/read/160745/5565946
˪-ii--
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账龄分析_PROC' AND TYPE='P')
DROP PROC 应收账龄分析_PROC
GO
create PROC 应收账龄分析_PROC
AS
create table #收款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/160745/5566039
˪
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应付账龄分析_PROC' AND TYPE='P')
DROP PROC 应付账龄分析_PROC
GO
create PROC 应付账龄分析_PROC
AS
create table #付款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/192983/8259811
sql sample20.sql
/* 文件名称: Sample20.sql */
USE 北风贸易
SELECT 姓名,员工性别,电话号码,出生日期
FROM 飞狐工作室
WHERE 员工性别 = 0 AND
DATEDIFF(yy,出生日期,GETDATE()) < 30 AND
部门 = '资讯部'
www.eeworm.com/read/192983/8259905
sql sample91.sql
/* 文件名称: Sample91.sql */
USE 北风贸易
SELECT 姓名,年龄 = DateDiff(yy,出生日期,GETDATE())
FROM 飞狐工作室
ORDER BY 年龄 DESC
SELECT 姓名,年龄 = DateDiff(yy,出生日期,GETDATE())
FROM 飞狐工作室
ORDER BY 2 DES
www.eeworm.com/read/192983/8260230
sql sample104.sql
/* 文件名称: Sample104.sql */
USE 北风贸易
SELECT 姓名,
年龄 = DATEDIFF(yy,出生日期,GETDATE())
FROM 飞狐工作室
WHERE DATEDIFF(yy,出生日期,GETDATE()) BETWEEN 30 AND 40
www.eeworm.com/read/192983/8260293
sql sample137.sql
/* 文件名称: Sample137.sql */
USE 北风贸易
SELECT COUNT(*) FROM 飞狐工作室
WHERE DATEDIFF(yy,出生日期,GETDATE()) BETWEEN 30 AND 40
www.eeworm.com/read/247504/12655106
sql 应收账龄分析_proc.sql
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账龄分析_PROC' AND TYPE='P')
DROP PROC 应收账龄分析_PROC
GO
create PROC 应收账龄分析_PROC
AS
create table #收款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/247504/12655713
sql 应付账龄分析_proc.sql
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应付账龄分析_PROC' AND TYPE='P')
DROP PROC 应付账龄分析_PROC
GO
create PROC 应付账龄分析_PROC
AS
create table #付款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM