| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How will u get 5 years back record? | | 4 |
| 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 |
| How many index keys possible for a table | | 6 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| What is a join and their types? | Challenger-Financial | 2 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| What is a trigger? | | 3 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| Explain the storage models of OLAP? | | 1 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
| what are batch in sql server?
| Satyam | 2 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| About Indexed Views? with example?
plz reply... | | 2 |
| Why Do you want to work in this company? | HCL | 3 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |