| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain Different types of Projects? | | 1 |
| How do you find the number of rows in a table? | | 5 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| what is a cursor and what is its use? | | 1 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| what is a stored procedure and trigger? | | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| How to link up the text file to a Database table? | Allianz | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| What is Deadlock? | Satyam | 3 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| what is difference between nchar and char in Sql server ?
| | 2 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| What is a sub-query? When would you use one? | | 3 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| What value could be assigned to Varchar Type? | | 3 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
