SQL Server Interview Questions
Questions Answers Views Company eMail

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 12581

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 1615

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?

Deloitte, Lason,

9 17280




A left outer join B B right outer join A gives the same result then what is the use of two?

1 3364

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 5960

event classes in sql server

Accenture, AFE,

2 4294

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

L&T, CarrizalSoft Technologies,

4 7160

what is macro?

Wipro, Excel, Global Innovation,

5 8448




After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

850

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 2936

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 9530

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 6431

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 3725

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 11568

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 8534


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?

1175


You are doing log shipping due to some reasons it is failing. How you will proceed from there

771


how to overcome kernel isssues

435


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

616


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605






what is isolation level at dead lock?

968


role of sql sever 2005 in database rather than any other database

834


Does any body please help me what question's have asked for SSRS in the interview?

794


What is data modeling and Reterminal integrity?

618


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

752


whats the maximum size of view state??

892


what is checksum in sql server.........???

338


what is package and it uses and how can u call a package

835


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1450


What is best institute to Learn DotNET And SQL in chennai?

912