| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how insert selected column only ? | Robert-Half | 2 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| How to count the number of duplicate items in a table? | | 1 |
| what is a stored procedure and trigger? | | 2 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| What is the difference between having and where clause? | | 4 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| How will u get 5 years back record? | | 4 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| what is curser. | | 9 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| What is a NOLOCK? | | 3 |
| What is a Lock and let me know Different types of locks? | | 1 |
| how to delete duplicate rows from table | CSC | 9 |
| what are file groups? | Evalueserve | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
