| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is an extended Stored Procedure? | | 1 |
| What is row by row processing ? | | 1 |
| How m-m relationships are implemented? | | 1 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 6 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| What is the difference between local table and global table | Polaris | 1 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What does the INSTEAD OF trigger do? | | 3 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| 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 IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| What are the two types of concurrency? | | 2 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| What are the authentication modes in SQL Server? | | 2 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
