account

[tracker62]

all account in the disorder

???????????
dbo.Users_Master



please

[kraken.zhangar]

First try to solve any problems you have, alone. And secondly UserUID is just nothing to this inconvenient

[tracker62]

how it

[JohnHeatz]

why would you need the to be in order anyways? that doesn't affect you on any way at all

[tracker62]

ID to find faster

[JohnHeatz]

Why not use a query?

select * from dbo.Users_Master where userUID = [number]

[tracker62]

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Users_Master'.

??

[taZツ]

select * from PS_UserData.dbo.Users_Master where userUID = 'number'

[JohnHeatz]

yeah that or at the beginning just put

Use PS_UserData

pretty simple, I suggest that you read a little bit about SQL and how to work with it, it is fun, easy and you will be able to fix 99% of the errors you get

[tracker62]

I have to do one by one

[JohnHeatz]

Obviously, as it was said before, anyways the UserUID is nothing that will help you on absolutely anything, I certainly don't have any idea on why you would try getting them in order but if you want to use this (and again a simple SQL query that must be known if you work with databases)

Use PS_UserData
Select * from dbo.Users_Master order by UserUID asc

[tracker62]

this to find faster the account name

[JohnHeatz]

I won't really give you the query now, because this is really basic, but there is something that is called a "complex query" which is a query made by mixing 2 or more queries to find information quickly on a "big" database, so I will just give you the idea and with it you will be more than able to figure it out, or at least read a bit about SQL Queries.

If you want to find an "account name" you can use one toon's name of that account and look for it on the chars table, now that you have the toon's name, then you go with it, and look for the account, having the data that can be used on both of the tables you are going to use (chars and users_master) you can combine the information and bring up the account name.

This can be done not just with this kind of information but when you learn to use these kind of queries, you will be capable of finding any information you need having just one parameter easily.

[tracker62]

thank you