| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| Explain Trigger with an example?
| | 1 |
| i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L | | 4 |
| what is web server?
| Satyam | 3 |
| how can i store resumes in database? | HCL | 2 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| What is a sub-query? When would you use one? | | 3 |
| What is referential integrity and how is it achieved? | Adea-Solutions | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| 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 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| Explain Different types of Projects? | | 1 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| What is the difference between UNION and UNIONALL? | CTS | 2 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| what operator performs pattern matching? | | 1 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
