| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is curser. | | 8 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| What are explicit and implicit transactions? | | 2 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| What are functions | | 3 |
| Can we call SP inside a query? | Wipro | 4 |
| How reterive duplicate value in SQL? | | 5 |
| 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 |
| What is de-normalization and when do you do it? | | 3 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| How to select nth record from a table? | DELL | 9 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| Difference between server.transfer and server.execute method? | | 1 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| What are Magic Table? | Evalueserve | 15 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| what is a cursor and what is its use? | | 1 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| |
| For more SQL Server Interview Questions Click Here |