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 8638

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 7608

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,

2291

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 6703

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 7316

How to get number of days in a given year?

ADP,

4 7618

Differencr Between DELETE and TRUNCATE?

ADP,

3 7725

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5685

How to get number of days in a given year?

ADP,

4 8793

Explain SELF JOIN ?

ADP,

3 7444

What is Index ? Explain its Types?

ADP,

2 7799

Define Foreign Key?

ADP, College School Exams Tests,

3 8830

Un-Answered Questions { SQL Server }

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2138

how you can move data or databases between servers and databases in sql server? : Sql server administration

1026

What is primary key and example?

994

Which are ddl commands?

1113

What does it mean to be in union?

979

How to create nested stored procedure?

1071

What happens if the update subquery returns no rows in ms sql server?

1173

What are wait types?

1197

How to declare and use cursor variables?

1250

What is a unique key constraint?

1085

Mention what are the core components of ssrs?

330

Why should you use or avoid select * statements?

1071

What is difference statement and preparedstatement?

1031

What is instead of dml trigger?

1054

Explain difference between cross join and full outer join?

1064

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