| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is MSDE? | | 2 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| Can we create a clustered index on composite primary key. | | 2 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| Why we need a group by clause? | | 3 |
| what is curser. | | 9 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 16 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| What is Schema? and why we use schemas? | | 1 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| Wht is SQL Injection Attack ? | | 1 |
| What is BCP? When do we use it? | | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| |
| 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
