| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can you explain the role of each service? | | 1 |
| how to select a field with firstletter as capital and
remaining are small letters | | 7 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 4 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| What's the maximum size of a row? | | 4 |
| What is data integrity? Explain constraints? | | 1 |
| Difference between Function and Stored Procedure? | C1-India | 3 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| Explain some DBCC commands? | | 3 |
| how to find nth highest salary | | 21 |
| How to tune a stored procedure? | | 4 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| Explain DBMS, RDBMS? | | 4 |
| What is a sub-query? When would you use one? | | 2 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 1 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 1 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| What are tasks? | Wipro | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
