摘要:
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER FUNCTION [dbo].[ufn_getDateOfWeek](@Date Datetime)RETURNS nchar(1)ASBEGIN DECLARE @returnValue nchar(... 阅读全文
posted @ 2014-10-06 20:56
dapeng888
阅读(306)
评论(0)
推荐(0)
摘要:
原文地址:http://hi.baidu.com/%BD%F0%D3%F1kl_y/blog/item/1c368ffba9388476024f5645.html--按mySql语法统计按周,月,季,年。income为合计的价格字段,createDate为交易时间。select sum(income... 阅读全文
posted @ 2014-10-06 20:55
dapeng888
阅读(2276)
评论(0)
推荐(0)
摘要:
一条例子: select count(point_id) as today_sum from point where datediff(d,point_date,getdate())=0 关键语句: datediff(d,point_date,getdate())=0 阅读全文
posted @ 2014-10-06 20:54
dapeng888
阅读(295)
评论(0)
推荐(0)
摘要:
ALTER proc [dbo].[SP_CreateInsertScript](@tablename nvarchar(256),@con nvarchar(400)) as begin set nocount on declare @sqlstr varchar(4000) declare @s... 阅读全文
posted @ 2014-10-06 20:53
dapeng888
阅读(361)
评论(0)
推荐(0)
摘要:
ufn_GetWeekFirstAndEndDay 获取指定日期所在星期的第一天和最后一天日期ALTER FUNCTION [dbo].[ufn_GetWeekFirstAndEndDay](@tmpDate DATETIME)RETURNS @tmpTable TABLE( FirstDay D... 阅读全文
posted @ 2014-10-06 20:46
dapeng888
阅读(678)
评论(0)
推荐(0)

浙公网安备 33010602011771号