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 13250

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 1889

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 18533




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

1 3568

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 6189

event classes in sql server

Accenture, AFE,

2 4670

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

L&T, CarrizalSoft Technologies,

4 7525

what is macro?

Wipro, Excel, Global Innovation,

5 8649




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

Cognizant,

977

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 3191

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

1 9959

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

Zenith,

1 6749

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

Apollo,

2 3940

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

2 12482

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

1 8891


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

1042


Issues related in upgrading SQL Server 2000 to 2005 / 2008

855


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

887


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

428


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

747






Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1418


Why do you want to join software field as you have done your BE in Electronics?

1093


ow to bring suspect mode datbase online from scratch

759


How to convert a table data in XML format in sql server?

1480


what is the sql equivaent of the dataset relation object ?

905


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4881


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1017


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

939


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

771