| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Why we need a group by clause? | | 3 |
| Can we call SP inside a query? | Wipro | 4 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| What is a view? | | 4 |
| Explain the new features of SQL server 2000? | | 1 |
| What is a Lock and let me know Different types of locks? | | 1 |
| how to find nth highest salary | NexGen | 30 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| what operator performs pattern matching? | | 1 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| could u plz explain about joins and views? | | 2 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| Can you have a nested transaction? | HCL | 3 |
| plz send every query in sql server2000 | Infosys | 1 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |