January 5, 2016 at 2:58 am
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
January 5, 2016 at 3:46 am
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]
January 6, 2016 at 8:14 am
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
January 8, 2016 at 7:29 am
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.
January 8, 2016 at 8:00 am
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
January 8, 2016 at 8:01 am
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
January 8, 2016 at 1:29 pm
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
Change is inevitable... Change for the better is not.
January 8, 2016 at 10:46 pm
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply