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 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.
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
Reference : Pinal Dave (https://blog.sqlauthority.com)
160 Comments. Leave new
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?