Lil tip for junior ADM

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=)

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.

Quote:

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

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

Quote:

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. ;)

Quote:

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=)

Quote:

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

Quote:

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...

Quote:

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. ;)

Quote:

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 ;)

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

Quote:

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...

LAZY BONEZ xD

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

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 [Only registered and activated users can see links. Click Here To Register...] is where to find all information needed