| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Questions regarding Raiseerror? | | 1 |
| which database is best to use in oracle and sql server?
explain reasons? | TCS | 5 |
| how to rename the table | | 3 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 11 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| how to know Who Is Blocking Your SQL Server? | | 3 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| Hello all,
I have data like :-
year amt
2004 10
2005 20
2006 30
Now i want output as:-
2004 2005 2006
10 30 60
but i have to use here group by on year.So, i need a single
query within that i can find.
| | 2 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| How to tune a stored procedure? | | 5 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| |
| 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
