Delete Item

[S37uP!Update]

Hello all,i want to know how can i delete some item from all members already registered,from port service,invetory,or equiped?
Eg:i want to remove 1 pet from all member,how can i do that?withou deleting on each one of them possibly a query or something ...

Nobody?

[MentaL]

[Alphakilo23]

Excuse me for digging up a thread this old. But I find this quite interesting.

You may have noticed that all the items are stored in some weird, binary way (which insults the concept of relational databases, but meh).
Anyway, what you could try is the following (should be realisable in TSQL):

1. Loop though all the the "equipment" and "warehouse" fields which contains item data;
2. Decode them (you might find this thread helpful);
3. (Invoke a transaction);
4. Delete the item;
5. Write it back;
6. (End the transaction);

Other stuff you might find helpful:
T-SQL Programming Part 1 - Defining Variables, and IF...ELSE logic
T-SQL Programming Part 2 - Building a T-SQL Loop
Transaction Fundamentals

[S37uP!Update]

Wow,nice steps,working.