| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Schema? and why we use schemas? | | 1 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| What are constraints? Explain different types of
constraints? | | 6 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| how to know Who Is Blocking Your SQL Server? | | 3 |
| what is difference between having and where clause ? | | 2 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| What are cursors? | | 8 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| How To delete duplicate record from a particular table? | eXensys | 10 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| Explain Different types of Projects? | | 1 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| Different Types of Functions ?
| Satyam | 2 |
| What are the four main query statements? | | 3 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
