当我在sql表中更新表单时应该更新相同的groupname来给出数字 [英] When I update form in sql table should update same groupname to give number

问题描述

请看屏幕截图，下面



屏幕截图

Hi,

please see screen shot,below

screen shot

http://www.dotnetspider.com/attachments/forum/334710-2161-update2.png

SELECT CourseID,CRModuleId,CRModule_Name,CRModule_LevelId,CRModule_RefCourseId,CRModule_RefCourseName
             FROM CR_Modules
        INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
        INNER JOIN Course on CourseID = CRLevel_CourseId
        Where CourseID=5273

CourseID	CRModuleId	CRModule_Name	CRModule_LevelId	CRModule_RefCourseId	CRModule_RefCourseName
5244	32	Module 1	476581	1	Course 1
5244	33	Module 2	476816	1	Course 1
5244	33	Module 3	476817	1	Course 1
5244	33	Module 4	476818	1	Course english
5244	33	Module 5	476819	1	Course english
5273	40	test Level1	477114	31	test Maths
5273	41	test Level2	477115	31	test Maths
5273	42	test Level3	477116	31	test Maths1
5273	43	test Level4	477117	31	test Maths1

****************** *********************************************** >
i需要更新查询同名（CRModule_RefCourseName）我添加到数字+ 1，

CRModule_RefCourseId。



我想要编辑此查询？此条件

*****************************************************************
i need update query same name (CRModule_RefCourseName) i add to number + 1,
CRModule_RefCourseId .

I want edit this query? for this condition

update CR_Modules set CRModule_RefCourseId = (select (max(CRModule_RefCourseId)+1) CRModule_RefCourseId
        FROM CR_Modules
        INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
        INNER JOIN Course on CourseID = CRLevel_CourseId
        Where CourseID=5273
        )
        from CR_Modules
        INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
        INNER JOIN Course on CourseID = CRLevel_CourseId
        Where CourseID=5273

谢谢，

karthikeyan

thanks,
karthikeyan

推荐答案

这篇关于当我在sql表中更新表单时应该更新相同的groupname来给出数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！