| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| What is a view? is View updatable? | IBM | 11 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| How many index keys possible for a table | | 6 |
| How do we rollback the table data in SQL Server | | 3 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| Explain Trigger with an example?
| | 1 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| syntax for deleting the database in T SQL | | 4 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| What are the four main query statements? | | 3 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| |
| For more SQL Server Interview Questions Click Here |