| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the two types of concurrency? | | 2 |
| what is the cursor life span? | Evalueserve | 5 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 2 |
| how can do you the system monitoring? | | 1 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| How can u convert the Date to String? | TCS | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| Explain Trigger with an example?
| | 1 |
| How to Debug a Stored Procedure? | Allianz | 4 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| What is a Trace frag?Where can we use this? | | 1 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| Which virtual table does a trigger use? | | 3 |
| CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType
varchar(50) )
go
create trigger hpms_create_Insert
on HPMS_CompetencyTypes
for insert
as
if Exists ( select * from [HPMS_CompetencyTypes] where
CompetencyType=(select * from [HPMS_CompetencyTypes]))
begin
Rollback tran
Raiserror ('duplicate value',12,6)
go
insert HPMS_CompetencyTypes (CompetencyType) values ('new')
I'm new to trigger can any one tell me where is the issue.
Please. | | 2 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
