| Other SQL Server Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| Can we create a clustered index on composite primary key. |
IGT | 2 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? |
| 2 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? |
Techno-Solutions | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? |
| 1 |
| How to Handle the exceptions in Sqlsrver 2005?? |
Value-Labs | 3 |
| What is the SQL????????????????????????????? |
CMS | 5 |
| 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
|
| 14 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? |
| 2 |
| What about UPDATESTATISTICS ? |
Intelligroup | 2 |
| Explain Trigger with an example?
|
| 2 |
| What is INTVAL( )and where we use
Plz any body help me |
| 1 |
| what is the difference between procedure and function. |
Thomson | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
