| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 6 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| What are constraints? Explain different types of
constraints? | | 4 |
| can you any body tell me the how to decrease the logfile | | 2 |
| what is Archive old data? | | 1 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 1 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 1 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 3 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| Different Types of Functions ?
| Satyam | 2 |
| What is Covering Indexes?
Plz explain with example | | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 1 |
| How will u get 5 years back record? | | 3 |
| How m-m relationships are implemented? | | 1 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map