Interview Questions and Answers are now updated with the latest questions and answers. New Location: SQL Server Interview Questions and Answers.
Click here to get free chapters (PDF) in the mailbox
Thank you all for your appreciation about the my recent series of SQL Server Interview Questions and Answers. I enjoyed writing questions and answers. I have gotten many emails about complete series.
Top most requests were to collect series in one big post so they can be easily used. I was asked to provide links to download them so they can be printed and referred.
Another question I received is done I ask the same questions in interviews which I administrate. The answer is YES. Though, I have a few other questions, which I ask. All of them, I came up myself and answers are unique to questions and not available on-line. Well, long story short, I have compiled list of questions in one PDF. Please download them and use them in your next interview or just for reading purpose.
An interview Question and Answer discussion can be very helpful to both these individuals. It is simply a way to go back over the building blocks of a topic. Many times a simple review like this will help “jog” your memory, and all those previously-memorized facts will come flooding back to you. It is not a way to re-learn a topic, but a way to remind yourself of what you already know.
Download SQL Server Interview Question and Answers Complete List
Complete Series of SQL Server Interview Questions and Answers
Introduction, Part 1, Part 2, Part 3, Part 4, Part 5, Part 6
SQL Server Interview Question and Answers Complete List Download
Other popular Series
SQL SERVER Database Coding Standards and Guidelines Complete List Download
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
Connect with me on Twitter.
Reference: Pinal Dave (https://blog.sqlauthority.com)
282 Comments.
Hello Dave,
can you send me the frequently asked sql queries in interviews.
thanks
Anurag
Dear Pinal,
I have visited your web-site today itself and have found it very helpful.
My problem is that I have experience of 10+ years (in DOS-based applications like Clipper, Foxpro etc) and all logics are
clear and I have developed application softwares for almost
every field and are being used in the market. But I donot have any degree or diploma.
I have updated myself recently with new languages and now i am working with a company as a ERP programmer using SQL-Server 2000 and VB-2005. Please guide me accordingly so that I can see my future brighten. I belong to a small city but close to NCR.
I will be very thankful.
Best Regards,
ASHU
hai nice website
Hi Pinal,
I looked at your website, it really is nice. In addition to fundamentals of database. Do you in case have a list of sql excercises we can try for say Employee,Department example.
Things where someone needs to think hard. It could be a good excercise in problem solving.
For instance, how to delete duplicate rows from a table. Questions like that..
Let me know what you think.
Thanks
Regards,
informer
hi dave,
i am new to sql server 2005.
can you please tell how to display error message in the result set when the data is not available in the table.
when i trying select data of one perticular column from db table if there is no record i want to display error message saying that this recored is not available so how to write query…
eg:if there are 10 emp_id from emp tb if i select emp_id from emp where emp_id=11
in the result set i need display 11 not available
thanks in advance
Send me the SQL server Qans.
This is simply Superb to give such an information for the beginers as well as experts.
I have updated myself recently with new languages and now i am working with a company as a ERP programmer using SQL-Server 2000 and VB-2005. Please guide me accordingly so that I can see my future brighten. I belong to a small city but close to NCR.
I will be very thankful
Regards
SRINIVASA RAO
BHANUTEJ
How can we write a trigger so that before any insert is occured on a table it must check for certain values to be supplied for a table.If coorect insert, else not.
Plz Send me SQL Interview Questions
hi
can you pls send me SQL server interview question & answers
thanks
superb—————–
u r gr8,thnks a lot.
are there any interview questions for reporting services
could u plz send me interview questions asked in HR round regading urself, strenth & weaknesses etc
Thanks man. You are great.
Great links, questions and anwsers thanks for the info.
john
Hi Dave,
I always come to this site whenever i stuck somewhere.
You have taken gud initiative. Its realy helpful not only for persons who are looking for job also for others.
Just 1 week back i started to give some interviews. I find they are more concern with Database performance issues. I’m having 3 years of total it experience. So they didn’t ask me general database questions.
So can you please give some Q/A regarding DB performance.
Regards
Vineeta Agarwal
It is realy great, excellent web site.
Srinath.
DBA
Bangalore
Hi Pinal,
Thanks a lot for your interview questions. :)
your answers are good