SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

Indecomm,

7 8694

write a query to remove duplicate records without using primary key column?

ABCO,

2 9518

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7643

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

HCL, Wipro,

1 2303

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 6721

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 6280

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2141

what is Equity join?

ADP,

2 7335

How to get number of days in a given year?

ADP,

4 7655

Differencr Between DELETE and TRUNCATE?

ADP,

3 7770

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5708

How to get number of days in a given year?

ADP,

4 8829

Explain SELF JOIN ?

ADP,

3 7477

What is Index ? Explain its Types?

ADP,

2 7839

Define Foreign Key?

ADP, College School Exams Tests,

3 8880

Un-Answered Questions { SQL Server }

How do I create a trace in sql server?

1102

Equi join and non equi join is possible with sql server?

1110

How can we solve concurrency problems?

1110

Why should you use or avoid select * statements?

1094

What is the difference between upgrade and migration in sql server?

1163

Disadvantages of the indexes?

1205

Why we use the openxml clause?

1059

How to provide default values to function parameters?

1235

How do I find query history in sql server?

1000

What is clustered index

1069

What are the different SQL Server Versions you have worked on?

1071

How raid can influence database performance?

1093

How can I check that whether automatic statistic update is enabled or not?

1101

Explain system functions or built-in functions? What are different types of system functions?

1052

Explain “row_number()” in sql server with an example?

1061

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