摘要: 1 CREATE FUNCTION [dbo].[_GetDateInterval] 2 ( 3 @d1 as datetime, 4 @d2 as datetime 5 ) 6 RETURNS nvarchar(100) 7 AS 8 BEGIN 9 --函数默认@d1 <= @d2,如果@d1 阅读全文
posted @ 2021-03-16 09:13 奶油拌云朵 阅读(626) 评论(0) 推荐(0) 编辑
摘要: 1 CREATE PROCEDURE [dbo].[Getdatediff] 2 @fromdate nvarchar(10), 3 @todate nvarchar(10) 4 as 5 DECLARE @yeardiff 6 INTEGER DECLARE @monthdiff 7 INTEGE 阅读全文
posted @ 2021-03-15 16:44 奶油拌云朵 阅读(1117) 评论(0) 推荐(0) 编辑