06 2016 档案

Redis Fun使用
摘要：using Newtonsoft.Json; using StackExchange.Redis; using System; using System.Configuration; using System.Reflection; using System.Threading.Tasks; using System.Text; namespace Lemon.Common { pub... 阅读全文
posted @ 2016-06-21 15:11 大空白纸 阅读(720) 评论(0) 推荐(0) 编辑
mssql 创建存储过程简单实例
摘要：CREATE procedure [dbo].[cp_User_Increment] @channelId int, @currentPage int, @pageSize int, @userId int as if @channelId<=0 begin select CurrentTime, Cou... 阅读全文
posted @ 2016-06-01 09:36 大空白纸 阅读(988) 评论(1) 推荐(0) 编辑
mssql 创建函数简单实例
摘要：CREATE FUNCTION [dbo].[f_DailyIncome] ( @userId int, @date date ) RETURNS decimal(18,2) AS BEGIN declare @income decimal(18,2); select @income = ISNULL(sum(uc.[TotalFee]*bcl.[Percent]),0)... 阅读全文
posted @ 2016-06-01 09:34 大空白纸 阅读(735) 评论(0) 推荐(0) 编辑