| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| what is the difference between sql query and google query? | TCS | 2 |
| select empid empname from employee
What is the result for the about query? | | 3 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What are cursors? | | 7 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 2 |
| What is the default value of CHAR type? | Bosch | 6 |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| how to know description of a table in sqlserver 2000
| | 6 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| What is lock escalation? | | 1 |
| How can i change the column name. | HCL | 6 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 3 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| How to find the date and time of last updated table? | | 3 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 2 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| Advantages and Disadvantages of Cursor? | Zenith | 4 |
| |
| For more SQL Server Interview Questions Click Here |