| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 11 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 16 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| How do you know which index a table is using? | | 4 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| What is the difference between local table and global table | Polaris | 1 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| Can we create a clustered index on composite primary key. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |