| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 2 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 1 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| Wht is the difference between stored procedure and trigger | TCS | 2 |
| What is the difference between temp table and table variable? | Microsoft | 3 |
| what is meant by deafult in sql server?
| | 2 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| What is transaction ? Give me one example. | Melstar | 7 |
| what is hash table | Teledata | 2 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| Explain the architecture of SQL Server? | | 2 |
| What are the two types of concurrency? | | 2 |
| How do you fine the performance tunning? | Accenture | 2 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| How to find the date and time of last updated table? | | 3 |
| 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 | 4 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
