UPDATE
[Organization]
SET
CASE @CourseTypeID WHEN 0 THEN [ConcurrentUserLicenses] =[ConcurrentUserLicenses] - 1
ELSE InstructorLedCourseLicenses=InstructorLedCourseLicenses -1
WHERE
[OrganizationID] = @OrganizationID我想实现的功能是这样的
中的SET 语句怎么写呢? 谢谢
[Organization]
SET
CASE @CourseTypeID WHEN 0 THEN [ConcurrentUserLicenses] =[ConcurrentUserLicenses] - 1
ELSE InstructorLedCourseLicenses=InstructorLedCourseLicenses -1
WHERE
[OrganizationID] = @OrganizationID我想实现的功能是这样的
中的SET 语句怎么写呢? 谢谢
解决方案 »
- sql2000 + WIN2003的问题!
- 三个表可不可以JOIN啊?怎么做啊?
- 动态exec查询N多个相同结构的表,varchar的长度不够,怎么处理?
- 如何建立二个表对一个表的级联删除关系?
- PL/SQL如何做两个表的全外连接(full outer join)?答对马上结贴。
- 我的系统是win2000 pro,装的是sql person ,但总是最后安装完配置的时候失败???里面是日志
- 有点难度,看题
- 简单的sql语句,如何把两个字段连接起来作为一个字段。
- "list index out of bounds(8)"这种错是什么意思呀???
- 跪求sql server的语句练习语句(复杂点得)
- HELP!SQL 启动不了!
- 这个sp该怎么写效率才高
SET [ConcurrentUserLicenses]=CASE @CourseTypeID WHEN 0 THEN
[ConcurrentUserLicenses] - 1
ELSE InstructorLedCourseLicenses -1 end
WHERE [OrganizationID] = @OrganizationID
[Organization]
SET
ConcurrentUserLicenses = (Case When @CourseTypeID = 0 Then ConcurrentUserLicenses - 1 End),
InstructorLedCourseLicenses = (Case When @CourseTypeID != 0 Then InstructorLedCourseLicenses - 1 End)
WHERE
[OrganizationID] = @OrganizationID
SET [ConcurrentUserLicenses]=CASE @CourseTypeID WHEN 0 THEN [ConcurrentUserLicenses] - 1
ELSE InstructorLedCourseLicenses -1 end
WHERE [OrganizationID] = @OrganizationID
语法的问题
SET ConcurrentUserLicenses=CASE WHEN @CourseTypeID=0 THEN ConcurrentUserLicenses - 1
else ConcurrentUserLicenses end,
SET InstructorLedCourseLicenses=CASE WHEN @CourseTypeID=0 THEN InstructorLedCourseLicenses - 1
else InstructorLedCourseLicenses end
WHERE [OrganizationID] = @OrganizationID
SET ConcurrentUserLicenses=CASE WHEN @CourseTypeID=0 THEN ConcurrentUserLicenses - 1
else ConcurrentUserLicenses end,
SET InstructorLedCourseLicenses=
CASE WHEN @CourseTypeID<>0 THEN InstructorLedCourseLicenses - 1
else InstructorLedCourseLicenses end
WHERE [OrganizationID] = @OrganizationID
[Organization]
SET
ConcurrentUserLicenses = (Case When @CourseTypeID = 0 Then ConcurrentUserLicenses - 1 Else ConcurrentUserLicenses End),
InstructorLedCourseLicenses = (Case When @CourseTypeID != 0 Then InstructorLedCourseLicenses - 1 Else InstructorLedCourseLicenses End)
WHERE
[OrganizationID] = @OrganizationID