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.
Hi Dave,
As Mr.Wanderer question regarding Delete/Truncate difference,I cant able to understand,can u explain with example..
Regards
P.Praveenkumar
Hi Dave
I got a question in SQL SERVER. How can v delete a row form a table without using delete keyword. Is it possible?
If so, tell me the way?
Regards,
Prasanna S
Hi dave
All ready the table contains some records, my question is i want delete the particular row from the table
Ex:
If table XYZ contains..
S.NO NAME DEPT …..
1 XXXX CSE
2 YYYYY IT
3 zzzzz MECH
From the above mentioned,I want to delete the record which contains dept IT. But without using DELETE keyword.
Hi Dave,
As Mr.Wanderer I worked with his example He is correct Truncate gets Rollback
But I am not getting your explanation which u given for Wanderer
Kindly clarify me with example
very useful to us please me
Hi dave,
I got cleared for what u say for delete a record without using delete keyword. thanks.
Regards,
Prasanna S
hello
i have a question the work to #tempTable is better or the work To dataTable In VB.net(2003) Which Is Faster?
thank you
Hi Dave,
Thats Really Great Job…..
All the Best…………
Parmod Bhardwaj
Gurgaon
Dear dave,
1. How to i drop all the trigger at a time ,
is there is any way as single T-SQL statement give some breif example.
2. How can i excute trigger with sql statement
with regards
Vijay.B
Hi pinal dave
Your site is really got useful infos. Please put some more
technical faq in depth in sql server questions on execution plan
and the performance and tuning questions.
Thanks man
Saravan
Interview Question of SQL SERVER
Excellnt website
Hi Dave,
your sql server interview ques and answers are really very very helpful to who is hunting for job….
All The Best …..
Thanks …….
– Chandrashekhar & Smita
i had a query which was working fine in 65 and 80 but suddenly it just stopped working in 80 and I have no idea what caused it?
The commented code was working in 65 but for 80 we wrote the other part (uncommented one).
select distinct
rt.Description,
— FullName = case c.FirstName when null then null else c.FirstName + ‘ ‘ end
— + case c.MiddleName when null then null else c.MiddleName + ‘ ‘ end
— + c.LastName,
FullName = ltrim(isnull(c.FirstName, ‘ ‘) + ‘ ‘ + case c.MiddleName when null then ltrim(”) else c.MiddleName + ‘ ‘ end + c.LastName),
s.ContactNum,
s.ReportType
from ReportType rt
inner join Subscription s on (rt.ReportType = s.ReportType)
inner join Contact c on (s.ContactNum = c.ContactNum)
where rt.OnDemand = 1
Hi Pinal Dave,
I am having over 100 databases in an enterprise.
For some reason i need to have some data from some of the tables from almost every database into a centralized database. I was thinking of using triggers “On update” on all those tables for this purpose, which will update the central DB as soon as a new record is created in any DB. But In most of the tables i m using composite keys. So i m not getting the last created primary key in the table. I have tried SCOPE_IDENTITY() and IDENT_CURRENT(”). Also it is not a feasible solution to use triggers in every database.
Can u please tell me how i can do that. If possible can u suggest any other integration method, but it should be a real time solution.
Thank you Sir………………….
Congratulations! Excellent Web Site!
I am new to sql server 2005, after gone to the entire questionnaire. I have got a very good knowledge of sql server 2005.
Excellent Job done!
Regards
Sadanand
Excellent Work Pinal!
In fact, there are many DBA’s around the world, but very few would share information like you.
Appreciate all your hard work & done a great Job.
Regards
Parvinder
Hi , Thanks a lot for doinog this job
Hi Pinal,
Wonderfull Job . I appreciate your hard work and intelligency. You had understood the requirement of the person thrust of Job.
Thank You Very Much.
Regards:
Prakash Nandwana