| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| select empid empname from employee
What is the result for the about query? | | 4 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| write the query for find the top 2 highest salary in sql
server | TCS | 23 |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| What are the types of model in sql server and explain | TCS | 1 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
