| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different types of joins and what does each do? | | 2 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| how to rest identity columns in sql server | Matrix | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| can any one please send sql quries most used in applications. | | 1 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| i want table name basis on column name. | | 2 |
| What is an extended Stored Procedure? | | 1 |
| What is a Linked Server? | | 1 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| what are batch in sql server?
| Satyam | 2 |
| Different Types of Functions ?
| Satyam | 2 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 1 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 8 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 2 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 5 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |