Learning is an extremely important part of life. From the first step, everybody progresses in life and learns something new. Earlier this year, SQLAuthority.com had a month-long series on SQL Server Interview Questions. It was extremely popular series, and I received a lot of encouraging comments. While I compiled the received feedback, one important feedback was the need of good basic learning. The reason for writing this series is to present a proper learning structure rather than a simple blog post.
And here is your chance to win some exciting gifts – For the next 35 days, every day at SQLAuthority.com, we are giving away two SQL Books.
Yes, you heard it right! – TWO SQL Server books are given away every single day for the next 35 days. No eBooks, but books in hard-copy, which you can carry around and read at your convenience. You can win these books very easily.
You just have to take a simple quiz at the end of the each blog post, and we will ship two SQL Books every day to a random winner.
Rules:
Please leave your answer in the comment section below with correct option, explanation, and your country of residence.
Every day one winner will be announced from United States.
Every day one winner will be announced from India.
The valid answer must contain country of residence of the answerer.
Please check my facebook page for winners’ names and correct answers.
The contest is open till the next blog post shows up at , which is next day GTM+2.5.
There is no purchase required and winner will be selected RANDOMLY.
Questions – Book 1
Questions – Book 2
Questions – Book 3
Question – Book 4
Question – Book 5
Q 29) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 29 of 35
Q 30) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35
Q 33) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
12 Comments. Leave new
HI Pinal,
This is really intresting game, i really appreciate your idea’s..
we ready to participate in the Game.. where is the qeustions ? how to answer them ?
you said that a PDF file will be avaliable at the end of last month for SQL Server Interview Questions.
can you say when it will be published.
by the way I love your blog, to bad the I cant participate in the game because i’m not from india or the United states.
Q 1: Answer : SELECT * FROM Customer WHERE Firstname = ‘[a-m]% ‘
Q 2:Answer :SELECT * FROM [Grant] WHERE GrantName = ‘_%[_]%_ ‘
Q 3:Answer :SELECT * FROM Employee WHERE Firstname like ‘%’% ‘
ShaliniMeyyappan From India
Thank you Pinal Sir, for this series.
SELECT * FROM Employee
WHERE Firstname like ‘%”%’ this is the only query which return all first names that have an apostrophe anywhere in the name
rest of the queries will either give syntax error or wont give all first names that have an apostrophe anywhere in the name
I am Sen Thomas from India, Bangalore
Sincere Thanks Pinal
I did not see the question for today but I am so glad that I found your site. GREAT Information! No wonder you are an MVP.
Thank you,
Ronda Pederson
Thanks Pinal for taking the time to do this. Like your post today about using Insert Select instead of Cursors, I have to admit I didn’t have a sql or programming background coming out of school and had to learn a lot as I went. I’ve had my share of bad code and there are still some things I do not understand well.
Every so often I run into this over() and partion() code in some of our more complicated queries and never quite got what it was doing even after doing some quick digging on the internet. I must say that after the last two days of questions I realized it is really simple and totally makes sense the way you have it explained. Thanks so much!
Hi pinal,
how can i sent my answers for this ongoing quiz?
Thanks again, Pinal, for this great contest and terrific blogs in this series
hii Pinal Sir,
I just want to know that how to count space between words in string like
“Fill in your details below or click an icon to log in” ie 11 with using SQL SERVER Query Please Tell Me.