| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain different isolation levels? | | 3 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| i want table name basis on column name. | | 5 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| What is normalization? | | 6 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| How can u convert the Date to String? | TCS | 4 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| What is a Stored Procedure? | | 7 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |