| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| What is blocking and how would you troubleshoot it? | | 1 |
| what is difference between primary key and Unique | | 8 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 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 | 5 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| Difference between server.transfer and server.execute method? | | 1 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| From where can you change the default port? | | 3 |
| What is SQL server agent? | SAP-Labs | 2 |
| How can u convert the Date to String? | TCS | 4 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |