| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can we call SP inside a query? | Wipro | 4 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| How m-m relationships are implemented? | | 1 |
| How to find the date and time of last updated table? | | 3 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| What is database normalization? | Digicel | 5 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| What is lock escalation? | | 1 |
| how do we find every fifth record in a table | | 11 |
| What is a stored procedure? | | 3 |
| what is maximum size of temp db? | iSoft | 4 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| What are the four main query statements? | | 3 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
