论坛 › 菜鸟学习资料 › 删除复制装备的SQL脚本命令

admin 发表于 2014-4-12 20:04:09

删除复制装备的SQL脚本命令

说明:
SQL脚本如下所示，请复制到SQL查询分析器中执行即可，建议做完备份再做些类的操作！如果你用的是GAME1数据库，请查找所有的GAME，改成GAME1，就可以了！

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table .
GO

CREATE TABLE . (
(15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
NULL ,
NOT NULL ,
(30) NOT NULL ,
NOT NULL ,
(10) COLLATE Chinese_PRC_CI_AS NULL
) ON
GO

--首先删除玩家刚摘下来的装备，就是TBL_ITEM表中，FLD_INDEX=0的那些装备
DELETE FROM .. WHERE = 0

--从玩家身上/包袱获取数据
INSERT INTO ..(, , ,,,)
SELECT , , , LTRIM(STR())+LTRIM(STR()) AS FLD_TID,,'身上' AS Place
FROM ..

GO

--从仓库获取数据
INSERT INTO ..(, , ,,,)
SELECT , , , LTRIM(STR())+LTRIM(STR()) AS FLD_TID,,'仓库' AS Place
FROM ..
GO

--从寄售获取数据
INSERT INTO ..(, , ,,,)
SELECT , , , LTRIM(STR())+LTRIM(STR()) AS FLD_TID,,'寄售' AS Place
FROM ..
GO

--记录将要删除的复制装备
if not exists (select * from dbo.sysobjects where id = object_id(N'..') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE .. (
[删除日期] datetime not null,
NOT NULL ,
[角色名] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[装备代码] NULL ,
[存放地点] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON
GO

INSERT INTO ..([删除日期],,[装备代码],[角色名],[存放地点])--,[装备名称]
SELECT getdate() as 删除日期, , -1 AS 装备代码, AS 角色名, AS 存放地点--, AS 装备名称
FROM ..
WHERE ((() In
(SELECT FROM As Tmp GROUP BY HAVING Count()>1 )))
ORDER BY
GO

--遂个删除复制装备
DECLARE @T_ID char (30),@I_MAKEINDEX int , @V_Place varchar (10)
DECLARE D_ITEMS_cursor CURSOR FOR
SELECT ,,
FROM ..
WHERE ((() In
(SELECT FROM As Tmp GROUP BY
HAVING Count()>1 )))
ORDER BY
OPEN D_ITEMS_cursor
FETCH NEXT FROM D_ITEMS_cursor INTO @T_ID,@I_MAKEINDEX,@V_Place
WHILE @@FETCH_STATUS = 0
BEGIN
IF @V_Place = '仓库'
DELETE FROM .. WHERE = @I_MAKEINDEX
ELSE IF @V_Place = '身上'
DELETE FROM .. WHERE = @I_MAKEINDEX
ELSE
DELETE FROM .. WHERE = @I_MAKEINDEX
END
FETCH NEXT FROM D_ITEMS_cursor INTO @T_ID,@I_MAKEINDEX,@V_Place
END
CLOSE D_ITEMS_cursor
DEALLOCATE D_ITEMS_cursor
GO

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table .
GO

zcteng 发表于 2014-5-1 09:28:12

收藏一下:'(

notgo 发表于 2014-5-4 13:51:34

学习一下！！

kuailecq3 发表于 2014-5-20 20:34:53

看看，学学

流浪儿 发表于 2014-5-23 02:45:11

弱弱的冒个泡！

lhy001 发表于 2014-6-5 00:20:08

感谢楼主的无私分享！支持怀旧论坛，支持本帖！

lzgm6801 发表于 2014-6-6 10:40:45

好好学习，天天向上。感谢分享{:2_33:}

wanlihong 发表于 2014-6-7 20:09:01

感谢楼主的无私分享！

lbtking 发表于 2014-6-22 10:27:21

受益匪浅！！！

mergerly 发表于 2014-6-26 14:04:12

弱弱的冒个泡！

查看完整版本: 删除复制装备的SQL脚本命令