| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| how to rename the table | | 3 |
| can any one please send sql quries most used in applications. | | 1 |
| Wht is SQL Injection Attack ? | | 1 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| What is a join and their types? | Challenger-Financial | 2 |
| How can I know what query is executing by by a particural
user? (using sp id or any othe way.) | | 2 |
| What are the four main query statements? | | 3 |
| 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 about UPDATESTATISTICS ? | Intelligroup | 2 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| Different Types of Functions ?
| Satyam | 2 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| what are batch in sql server?
| Satyam | 2 |
| What is the difference between login and a user? | TCS | 7 |
| What are the type of Indexes? which one is best, why? | | 5 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| How do you simulate a deadlock for testing purposes | | 1 |
| |
| For more SQL Server Interview Questions Click Here |