| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is index seek and index scan? | | 2 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| how to know Who Is Blocking Your SQL Server? | | 2 |
| What are functions | | 3 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| Can you have a nested transaction? | HCL | 3 |
| How do you persist objects, permissions in tempdb | | 1 |
| how many type of subquery? | | 2 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| Wht is SQL Injection Attack ? | | 1 |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| |
| For more SQL Server Interview Questions Click Here |