| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 1 |
| What is a Stored Procedure? | | 7 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| what are the problems in logshipping? | | 2 |
| what is the difference between sql query and google query? | TCS | 7 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| What are the two types of concurrency? | | 2 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| Can we create a clustered index on composite primary key. | | 2 |
| About DTS usage ? | Cognizent | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
