| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 11 |
| What is a sub-query? When would you use one? | | 3 |
| how to generate XML out of QUERY? | McAfee | 1 |
| What is the difference between UNION and UNIONALL? | CTS | 2 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| how to rest identity columns in sql server | Matrix | 3 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What is Schema? and why we use schemas? | | 1 |
| What is Deadlock? | Satyam | 3 |
| How to find the last update record in SQL Server? | | 3 |
| What is a trigger? | | 6 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| what is trigger | NIIT | 1 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What does the INSTEAD OF trigger do? | | 3 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| what is maximum size of temp db? | iSoft | 4 |
| What is de-normalization and when do you do it? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |