| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the cursor life span? | Evalueserve | 5 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 16 |
| what is diffence between replicaion and logshipping? | | 1 |
| What is a NOLOCK? | | 3 |
| What are the authentication modes in SQL Server? | | 2 |
| plz send every query in sql server2000 | Infosys | 1 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| 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 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| |
| For more SQL Server Interview Questions Click Here |