[MSSQL]How to find something from a table

[SeraphiPod]

Hmm,
This tut will be about MSSQL,
on how to find any rows w/ similar and exact name.

Okay, back to the tut.
•Finding an exact name on any column, row, or table.
1. Open MSSQL Management Studio
2. Click Open Query
Insert this code

use [color=red]gc[/color] select * from [color=red]goodsinfolist[/color] where [color=red]goodsname[/color]='[color=red]Insert Here[/color]'

Change the GoodsInfoList to your specific Table, the GC to your specific database, Insert Here to the name of you're finding (row), Goodsname as the name of the column of the row.

Example:

use gc select * from goodsinfolist where goodsname='Carta'

I used GC as Database, GoodsInfoList as the table where I will find the name of what is at the row, Goodsname as the column of the row, and the Carta as the what's on the row I'm finding.
3. Refresh / Execute.

*Sorry, I really can't explain, Testing is bettah.

•Finding a name w/ any similar to it:
1. Open MSSQL Management Studio
2. Click Open Query
Insert this code

 use [color=red]gc[/color] select * from [color=red]goodsinfolist[/color] where [color=red]goodsname[/color] like '%[color=red]Insert Here[/color]%'

**DO NOT ERASE THE %**
3. Refresh / Execute.

Hope this helps
Credits:
Jumong - for explaining how to and codes. 99.9%
SeraphiPod - Doing it ONLINE. 0.1%

-------
Some Items:
Carta Da Luna
Carta da Pixie
Foice da Nobreza
Pacote da Nobreza
Transformacao 3 / Transformacao3

 

[shiningriver]

Of course that is not limited to searching. You can do much, much more... but it's a nice tut.

 

[SeraphiPod]

^^, since many people does a hard work, searching for a item, w/ a very long list!!

 

[zhirakiz]

Now i can add some cash item , but hard to find item name . I'll translate it to eng soon !

 

[SeraphiPod]

baka.
use br client then logingame.
then list the items u want and search via this guide,.

 

[Node18]

Where's the open query button?

 

[SeraphiPod]

on the navigation bar where the execute is.
no SS./

 

[DF08Said]

hahaha good job Seraphipod

 

[Node18]

I may sound noobish but I still can't find the button. :/. Just to make sure, Microsoft SQL Server Management Studio Express 2005, correct?

 

[SeraphiPod]

correct.

/short/

 

[KaizoEX]

Can u post a pic on where can I find the "Open Query" button? I cant seem to find it!

 

[shiningriver]

click file, then click "open query"

 

[SeraphiPod]

Here:

---------------------------------------------------

 

[KaizoEX]

thx, and sorry for the trouble.

 

[SeraphiPod]

thx, and sorry for the trouble.

No Problem.

 

[TrikBoy101]

Thanks for the guides wlill be sure to use

 

[SeraphiPod]

sure ^^.
//short