摘要: 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 好学Ace 阅读(981) 评论(1) 推荐(0) 编辑
摘要: 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 好学Ace 阅读(729) 评论(0) 推荐(0) 编辑