Alter Proc [dbo].[UP_UserConsumeRecord_GetCountConsumeInvite_ByUserID]
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID and exists(select 1 from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID)return @InviteCount go
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID and exists(select 1 from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID)return @InviteCount go
Alter Proc [dbo].[UP_UserConsumeRecord_GetCountConsumeInvite_ByUserID]
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord
where ConsumeTypeID=1 and ConsumeuserID=@UserID
and exists(select 1 from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID)return @InviteCount go
return isnull(@InviteCount,0) Alter Proc [dbo].[UP_UserConsumeRecord_GetCountConsumeInvite_ByUserID]
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord
where ConsumeTypeID=1 and ConsumeuserID=@UserID
and exists(select 1 from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID)return isnull(@InviteCount,0) go
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord
where ConsumeTypeID=1 and ConsumeuserID=@UserID
and exists(select 1 from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID)return isnull(@InviteCount,0) --为NULL返回0,否则返回正常值 go
Alter Proc [dbo].[UP_UserConsumeRecord_GetCountConsumeInvite_ByUserID]
@UserID uniqueidentifier
as
declare @InviteCount int
set @InviteCount=0
select @InviteCount=sum(ConsumeInviteCount) from UserConsumeRecord
where ConsumeTypeID=1 and ConsumeuserID=@UserID return isnull(@InviteCount,0) --为NULL返回0,否则返回正常值 go
Alter Proc [dbo].[UP_UserConsumeRecord_GetCountConsumeInvite_ByUserID]
@UserID uniqueidentifier
as
declare @InviteCount int
select @InviteCount=isnull(sum(ConsumeInviteCount),0) from UserConsumeRecord where ConsumeTypeID=1 and ConsumeuserID=@UserID
return @InviteCount go