1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 18413

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 3202

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 26130

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

 1 4627

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 7594

event classes in sql server

Accenture, AFE,

2 6631

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 9809

what is macro?

Excel, Global Innovation, Wipro,

5 11015

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

Cognizant,

1621

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 4565

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

 1 11186

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

Zenith,

1 8313

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

Apollo,

2 5124

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

 2 15673

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

 1 10002

Un-Answered Questions { SQL Server }

What do you understand by a view?

545

What is pivot and unpivot?

628

What are sp_configure commands and set commands?

549

What do you understand by the data quality services in sql server?

485

what is a join and explain different types of joins? : Sql server database administration

527




Is mysql better than sql server?

528

Why de-normalization required?

560

What is bookmark link in ssrs?

108

What are the properties of the transaction?

531

Does sql server 2016 have ssms?

499

Can you move the resources after pausing the node? : sql server database administration

581

What is policy management?

571

Tell me what is de-normalization and what are some of the examples of it?

557

Do you know sql server 2008 introduces automatic auditing?

499

What are the transaction properties?

541

For More Un-Answered { SQL Server } Questions Click Here