| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| How reterive duplicate value in SQL? | | 5 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| Differnce between sel server 2000 and 2005 | | 3 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| What is difference between Triggers and store procedure? | | 2 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 16 |
| i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L | | 4 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| 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 Deadlock? | Satyam | 3 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| Can we create clustered index on non primary key column | CTS | 14 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
