The interview is a very important event for any person. A good interview leads to good career if the candidate is willing to learn. I always enjoy interviewing questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is a very large subject and not everything is usually asked in interview. In interview what matters the most is the learning attitude.
Interview Questions
An interview Question and Answer discussion can be beneficial 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.
I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the questions, please send me a mail or write a comment about interview questions.
Click here to get free chapters (PDF) in the mailbox
You can also connect with me on Twitter.
Reference: Pinal Dave (https://blog.sqlauthority.com)
160 Comments. Leave new
sir,
please tell me how to count the number of column in a table?
SELECT COUNT(SC.name) AS [Num of Columns]
FROM sys.objects SO
INNER JOIN sys.columns SC ON SC.object_id=SO.object_id
WHERE type = ‘U’ AND SO.name = ‘Your Table_Name’
sir plz solve my problem by query ,i.e. we need a query which select data from 2 tables –
1- male(table1)
2-female(table2)
we need to get data which give alternative male and females value on by one.
plz reply me.
It is ggod to have and prepare . Thank you in advance.
hello sir ,
i have this problem while attaching the northwind test database .as show
sir how i can slow this :
thank you
Regards sanaullah
TITLE: Microsoft SQL Server Management Studio
——————————
Attach database failed for Server ‘HP-PCSQLEXPRESS’. (Microsoft.SqlServer.Smo)
For help, click:
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Unable to open the physical file “C:SQL Server 2000 Sample Databasesnorthwnd.mdf”. Operating system error 5: “5(Access is denied.)”. (Microsoft SQL Server, Error: 5120)
very thanks man,
is there a way i can print this book.
What special Oracle feature allows you to specify how the cost based system treats a SQL statement
hey,can u tell me that,we are using oldb namespace in case oracle connectivity,and this also possible in case of sql2008 also,so what is needs to implement using.system,data,sqlclient
Hi all.this is just a great blog for sql. my question is this:
1. Write a database script that would achieve the following:
a. A DB Schema for a banking scenario that serves clients with both loans and savings. (use back page)
b. Database stored procedures to insert and/or update the database tables. (use back page)
how can i be able to do this
I bought your book with paper back but Is there anyway I can get online version like a ebook to read the same on my phone and computer?
Hai sir i have sql interview in this week in MNC . please give me any tips to study sql with in two days. pls help me sir.?
Hi Mr Pinal,
I have monitored your blog for quite some time and I am to oblige to say thank you for the good work. After several attempts I am still unable to download or find your books on MSSQL interview questions and answers. All the links are pointing in the locations and nothing is available to download. Can you please urgently help as I have a number of interview lined up and you are the only one who could truly help with the online (PDF) format of the interview questions and answers. Please reply to email.
Many Thanks.
Dee.
Is there a way to print the PDF? I am willing to purchase the PDF in order to print.
You can go with Kindle version.
Execellent post sir.
All questions are very usefull.
I have a query for select statement.
Suppose we have two records like ‘John Covil’ and ‘Jack peter’ and i want to match the string after the space in name. I mean suppose i search for ‘p’ the ‘Jack peter’ will be returned as after ‘Jack’ there is a space and ‘p’ is the first letter.
Can you please help me out with this.
Very Helpfulll
Great. Thanks @shankar
Hi,
Your Questions are really very helpful.
But I am unable to find the PDF for download.Can anyone help.
I tried but its redirecting to another page but theres no way to download it.
need a stored procedure for finding even numbers using loops
Try this
WITH t1 AS (SELECT 0 as num UNION ALL SELECT 0)
,t2 AS (SELECT 0 as num FROM t1 as a CROSS JOIN t1 as b)
,t3 AS (SELECT 0 as num FROM t2 as a CROSS JOIN t2 as b)
,t4 AS (SELECT 0 as num FROM t3 as a CROSS JOIN t3 as b)
,Tally (number)
AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) FROM t4)
SELECT number
FROM Tally where number%2=0;
Hi
i need sql support interview questions
i have a table data like this format
col1 col2
1 a
2 b
b 3
c 4
then finally i want to make my result set like
1 a
2 b
3 c
4 d
what is the logic behind this?