发帖回复

759阅读
0回复

[推荐]SQL修改特殊属性装备代码 [复制链接]

上一主题下一主题查看指定楼层

离线phands

发帖: *

祝福宝石: *

威望: *

玛雅之石: *

创造宝石: *

只看楼主倒序阅读使用道具楼主发表于: 2004-07-04

大于5的特殊属性全改为1并删除数据库为0代码的**物品

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC0] = 1 3v?R"2\qS
WHERE [FLD_DESC0] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC1] = 1 3v?R"2\qS
WHERE [FLD_DESC1] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC2] = 1 3v?R"2\qS
WHERE [FLD_DESC2] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC3] = 1 3v?R"2\qS
WHERE [FLD_DESC3] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC4] = 1 3v?R"2\qS
WHERE [FLD_DESC4] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC5] = 1 3v?R"2\qS
WHERE [FLD_DESC5] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC6] = 1 3v?R"2\qS
WHERE [FLD_DESC6] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC7] = 1 3v?R"2\qS
WHERE [FLD_DESC7] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC8] = 1 3v?R"2\qS
WHERE [FLD_DESC8] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC9] = 1 3v?R"2\qS
WHERE [FLD_DESC9] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC10] = 1 3v?R"2\qS
WHERE [FLD_DESC10] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC11] = 1 3v?R"2\qS
WHERE [FLD_DESC11] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC12] = 1 3v?R"2\qS
WHERE [FLD_DESC12] > 5

UPDATE [muddb].[dbo].[TBL_ITEM] 3v?R"2\qS
SET [FLD_DESC13] = 1 3v?R"2\qS
WHERE [FLD_DESC13] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC0] = 1 3v?R"2\qS
WHERE [FLD_DESC0] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC1] = 1 3v?R"2\qS
WHERE [FLD_DESC1] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC2] = 1 3v?R"2\qS
WHERE [FLD_DESC2] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC3] = 1 3v?R"2\qS
WHERE [FLD_DESC3] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC4] = 1 3v?R"2\qS
WHERE [FLD_DESC4] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC5] = 1 3v?R"2\qS
WHERE [FLD_DESC5] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC6] = 1 3v?R"2\qS
WHERE [FLD_DESC6] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC7] = 1 3v?R"2\qS
WHERE [FLD_DESC7] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC8] = 1 3v?R"2\qS
WHERE [FLD_DESC8] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC9] = 1 3v?R"2\qS
WHERE [FLD_DESC9] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC10] = 1 3v?R"2\qS
WHERE [FLD_DESC10] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC11] = 1 3v?R"2\qS
WHERE [FLD_DESC11] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 3v?R"2\qS
SET [FLD_DESC12] = 1 3v?R"2\qS
WHERE [FLD_DESC12] > 5

UPDATE [muddb].[dbo].[TBL_SAVEDITEM] 506AvD
SET [FLD_DESC13] = 1 506AvD
WHERE [FLD_DESC13] > 5

DELETE FROM [muddb].[dbo].[TBL_ITEM] 506AvD
WHERE [FLD_INDEX]=0 506AvD
DELETE FROM [muddb].[dbo].[TBL_SAVEDITEM] 506AvD
WHERE [FLD_INDEX]=0

评价一下你浏览此帖子的感受

分享到 淘江湖新浪 QQ微博 QQ空间开心人人豆瓣网易微博百度鲜果白社会飞信

发帖回复

返回列表


	http://www.chnteam.com 访问内容超出本站范围，不能确定是否安全


	关闭您还没有登录，快捷通道只有在登录后才能使用。立即登录还没有帐号？赶紧注册一个


	关闭选中1篇全选