Lil tip for junior ADM

[mongreldogg]

Hello!
Just wanna say that it will be very helpful if you read this book:
Martin Gruber - Understanding SQL.
You can find many diferrent translations in the Net. Use your search=)
Admin, share it please in download center=)

[Xijezu]

I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.

[Strange2010]

Originally Posted by Xijezu

I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.

+1 for this

i just learnt from looking at queries , its very simple

[mongreldogg]

True, but book contains not a lot info and very easy for learnin'.
And book contains info that you really want=)

[Xijezu]

Originally Posted by mongreldogg

And book contains info that you really want=)

When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.

[mongreldogg]

Originally Posted by Xijezu

When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.

Right, but many things may be useful=)
For example queries inside queries, sorting of data (useful if you creating any top pages), executing queries by using yr handmade program (info about this exists) and so=)

[Strange2010]

Originally Posted by Xijezu

When you just are working with Rappelz, which info's do you want?
sys-sp's? Casts/converts?
You only need the knowledge of SELECT, INSERT, UPDATE, DELETE and sometimes for some queries JOIN, but well, in this sections are hundrets of those Queries to understand those.

is creating stored procedures (smps) hard ? i hava a missing one and i know all the (@IN_XXX) values in it

[c1ph3r]

Originally Posted by Xijezu

I don't even see a sence of reading a book about MS SQL.
If you are able do understand English, you'll understand MS SQL (Rappelz-Stuff!) without a problem.

It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...

And i could cry if i see those guys rightclicking on the table selecting "edit top 200 rows". Or if i get questions like "how to edit lines which are not in the first 200 lines..."

Because of that 80% of this community should read something about SQL. This will eliminate about 70% of noob questions...If you don't know how to write stored procedures...you should google a bit or look through the other smps^^ SMPs are SQL Statements nothing more...

[Xijezu]

Originally Posted by c1ph3r

It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...

I was basing on Rappelz-Stuff.

[c1ph3r]

Originally Posted by c1ph3r

It's NEVER a bad idea to learn something about SQL since it is used in lots of working fields...

And i could cry if i see those guys rightclicking on the table selecting "edit top 200 rows". Or if i get questions like "how to edit lines which are not in the first 200 lines..."

Because of that 80% of this community should read something about SQL. This will eliminate about 70% of noob questions...If you don't know how to write stored procedures...you should google a bit or look through the other smps^^ SMPs are SQL Statements nothing more...

^this is based on my experiences with people trying to get an rappelz pserver running.

To correct myself:

Some people should google SQL at least before starting to create an pserver...it won't hurt and too much knowledge haven't killed someone till now

[TheOnlyOneRaskim]

I didnt googled it and got the basic´s into my Head. <.<

[c1ph3r]

Originally Posted by TheOnlyOneRaskim

I didnt googled it and got the basic´s into my Head. <.<

If your brain is healthy, present for 99% and your mother didn't throw you on the ground after your birth...you can learn by yourself otherwise you should google :P

Example:

If you are trying to edit the tables via "rightclick -> edit top 200 rows" start to google and stop spam around in the forum with n00b threads...

[mongreldogg]

LAZY BONEZ xD

[glandu2]

you can also change options to have "edit all rows"

the big problem with SQL is that every servers has different syntax (but yes we can only use mssql with rappelz)

and yes SQL is really easy, even without any knowledge it's easy to understand queries, else is where to find all information needed