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 8637

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

ABCO,

2 9485

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7605

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,

2290

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 6702

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 6230

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

2130

what is Equity join?

ADP,

2 7314

How to get number of days in a given year?

ADP,

4 7617

Differencr Between DELETE and TRUNCATE?

ADP,

3 7724

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5683

How to get number of days in a given year?

ADP,

4 8792

Explain SELF JOIN ?

ADP,

3 7443

What is Index ? Explain its Types?

ADP,

2 7799

Define Foreign Key?

ADP, College School Exams Tests,

3 8830

Un-Answered Questions { SQL Server }

Define outer join in sql server joins?

987

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

Explain how to maintain a fill factor in existing indexes?

1035

Name few endpoints exposed by ssrs 2012?

366

What is the recursive stored procedure in sql server?

1074

How to check status of stored procedure in sql server?

1037

How to create median function?

172

What are some examples of schemas?

1022

What is stored in the mssqlsystemresource database? : sql server database administration

1078

How will you go about resolving deadlocks?

1033

How to receive returning result from a query?

1188

Does windows server 2016 come with sql server?

984

Explain the steps to create and execute a user-defined function in the sql server?

1016

How can I check if a view exists in a sql server database?

1078

How to provide values to user defined function parameters?

1058

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