| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the new features of SQL server 2000? | | 1 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| What is the difference between constraints and triggers? | Wipro | 5 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 4 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| How do you find the number of rows in a table? | | 5 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 1 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| what are the problems in logshipping? | | 2 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| how to delete duplicate rows from table | CSC | 2 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| The Difference between 'Count' and 'Count(*)' | | 8 |
| What is ACID Property of Transaction? | | 3 |
| what is index seek and index scan? | | 2 |
| What is the difference between temp table and table variable? | Microsoft | 3 |
| How do we rollback the table data in SQL Server | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
