Where to start...

Question

Where to start...

Edvard Korsbæk

SSCertifiable

Points: 5994
More actions
January 5, 2016 at 2:58 am

#323360

Hi all!
You have been most helpfull over my time in this forum - Thanks.
My knowledge in scripting comes from http://www.w3schools.com/sql/ , but it is a bit basic, and i run into a wall a bit too often.
Of cause I could continue to let you solve my problems, but..
So, what would you recommand for reading to come a bit further than i am today?
At the time beeing, i need to use one dataset as limits for another dataset - and insert something, if nothing is there. Just an example - Don't try to answer on this documentation!
Best regards
Edvard Korsbæk

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

Well there are plenty of thing available here.

you can start with Stairways they are the best start from very basic and step by step they get to complex thing very easy to read too with examples you should try them. Following are few listed below.

Stairway to T-SQL: Beyond The Basics[/url]

Stairway to T-SQL DML[/url]

Stairway to Advanced T-SQL[/url]

Stairway to Database Design[/url]

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.

Additionally, because taking multiple approaches to learning is always best, I'd suggest tracking down your local user group and attend meetings there. You can find lots of local events through SQLPASS.org. These are almost always free to attend. You can also check out SQL Saturday events to see if there will be any in your area, SQLSaturday.com.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Kedazs SSC Veteran Points: 267 More actions · Answer 3

Never be afraid to ask for help. Read about all the topics you can. I find that eventually things will start to click. Immerse yourself.

You had one of the most knowledgeable SQL Server dudes reply to you in this thread (Gfritchey). Read his blog! That is what is so great about this community. EVERYBODY wants to help. Avoid those that do not want to.

Try looking at http://www.brentozar.com/ also.

Eric M Russell SSC Guru Points: 125561 More actions · Answer 4

Two common and simple patterns for inserting rows into TableA from TableB where the rows don't already exist in TableA.

INSERT INTO TableA ( id, a, b, c )

SELECT id, a, b, c FROM TableB

EXCEPT

SELECT id, a, b, c FROM TableA;

INSERT INTO TableA ( id, a, b, c )

SELECT B.id, B.a, B.b, B.c

FROM TableB B

LEFT OUTER JOIN TableA A ON A.id = B.id

WHERE A.id IS NULL;

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

RTaylor2208 SSChampion Points: 13298 More actions · Answer 5

Grant Fritchey (1/6/2016)
In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.

I'd very much 2nd this, Itzik really does write some excellent material when it comes to SQL Querying \ Programming.

MCITP SQL 2005, MCSA SQL 2012

Jeff Moden SSC Guru Points: 1004367 More actions · Answer 6

Edvard Korsbæk (1/5/2016)
So, what would you recommand for reading to come a bit further than i am today?

A lot of good books and articles have already been cited but, I have to tell you, none of them give you what you really need... practice and experience.

If you really want to get good at it, get yourself a copy of the SQL Server Developer's Edition and start answering questions on these very forums. As a newbie, you'll take the occasional hit here and there but see what other people have done and comparing it with your solution is one of the best teachers in the world and one of the fastest ways to get "experience" because most of the problems being posted are by real people with real problems in the real world.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 7

You can only master SQL by practicing. Check out the following links learn more about SQL in depth

https://msdn.microsoft.com/en-us/sqlserver/bb671058.aspx

https://www.mssqltips.com/[/url]

http://www.sqlserverlogexplorer.com/[/url]