| bsp; AS group_memberNum, ISNULL(uu_GroupInfo.fundCount, 0) AS fundCount,
(SELECT COUNT(*)
FROM Dv_Topic
WHERE Dv_Topic.BoardID = uu_GroupInfo.subforum_id) AS group_articleNum,
(SELECT COUNT(*)
FROM uu_GroupPhotos
WHERE uu_GroupPhotos.group_id = uu_GroupInfo.group_id) AS group_PhotoNum,
uu_GroupInfo.topic_account, uu_GroupInfo.hit_account,
(SELECT user_name
FROM uu_RegisterUser
WHERE uu_RegisterUser.user_id = uu_GroupInfo.creator_id)
AS group_CreatorName, uu_GroupInfo.create_time
FROM uu_GroupInfo INNER JOIN
uu_GroupType ON
uu_GroupInfo.group_type_id = uu_GroupType.group_type_id
三，存储过程的创建和调用
1，存储过程的调用
Execute procedureName @param=’value’
2，一个典型的带参数存储过程
CREATE PROCEDURE P_delMiniclassProc
@miniClassroom_id int
AS
declare @billtag varchar(4)
set nocount on
IF @miniClassroom_id is null
begin
return(-1)
end
else
BEGIN TRANSACTION
--删除套餐信息
DELETE FROM uu_SuiteToMinClassroomSect
WHERE min_classroom_sect_id IN
(SELECT min_classroom_sect_id
FROM uu_MinClassroomSect
WHERE min_classroom_id =@miniClassroom_id)
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] 下一页 | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 