TopSystem - Swap Field Value Form 2Record
来源:互联网 发布:电脑自动朗读软件 编辑:程序博客网 时间:2024/06/16 07:39
USE [MHQST_GameDB]
GO
/****** Object: StoredProcedure [dbo].[Arena_Get_Rival] Script Date: 10/16/2012 20:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--BM_Add 12.10.10-16.29
ALTER PROCEDURE [dbo].[Arena_Get_Rival]
@Challenge int
,@Rival int
AS
BEGIN
UPDATE T_Player
SET ArenaTop = (CASE
WHEN RoleID = @Challenge THEN
(SELECT ArenaTop FROM T_Player WHERE RoleID = @Rival)
WHEN RoleID = @Rival THEN
(SELECT ArenaTop FROM T_Player WHERE RoleID = @Challenge)
END)
WHERE RoleID = @Challenge OR RoleID = @Rival;
END
GO
/****** Object: StoredProcedure [dbo].[Arena_Get_Rival] Script Date: 10/16/2012 20:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--BM_Add 12.10.10-16.29
ALTER PROCEDURE [dbo].[Arena_Get_Rival]
@Challenge int
,@Rival int
AS
BEGIN
UPDATE T_Player
SET ArenaTop = (CASE
WHEN RoleID = @Challenge THEN
(SELECT ArenaTop FROM T_Player WHERE RoleID = @Rival)
WHEN RoleID = @Rival THEN
(SELECT ArenaTop FROM T_Player WHERE RoleID = @Challenge)
END)
WHERE RoleID = @Challenge OR RoleID = @Rival;
END
- TopSystem - Swap Field Value Form 2Record
- Flume Error must not generate more than one output value per record field解决
- _CR(Record, TYPE, Field)
- 文件上传时异常Invalid field value for field "**"与enctype="multipart/form-data"
- Dynamics CRM2016 The value of field on record of type entity is outside the valid range问题的解决方法
- Extracting Record and Field Metadata
- SetCursorPos for Error Record.Field
- Ext_Ext.form.Field基类
- ExtJs_Ext.form.Field解说
- ext.form.field.Date
- swap two value
- function showURL(value, metaData, record){
- solr查询 field:value 脚本
- Ext.form.field.File示例
- extjs4.1 form field clear
- Ext.form.Field.prototype.msgTarget
- Ext.form.field.ComboBox示例
- Ext.form.field.ComboBox示例
- IOS的AppDelegate方法中的事件触发调用
- ldd3 所有错误修改补订 基于linux-2.6.35
- 查询v$lock视图慢到Hang住
- OpenSSL
- 用Stopwatch类来测试你的程序运行时间
- TopSystem - Swap Field Value Form 2Record
- 微量知识 微博 经济 健康 禅语 笑话 古诗 化妆
- ld选项的english说明
- HDU 4118 && ZOJ 3659
- WebKit之WebCore篇
- Shell中的特殊字符$的含义以及实例
- ASP.NET中文件上传下载方法集合(上传限制,保存方式-二进制或文件形式,上传Internet上的资源 )
- 选择排序
- Windows核心编程学习笔记(1)--显示GetLastError错误的详细信息