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 8433

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

ABCO,

2 9390

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7465

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,

2241

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 6632

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 6055

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

2089

what is Equity join?

ADP,

2 7198

How to get number of days in a given year?

ADP,

4 7500

Differencr Between DELETE and TRUNCATE?

ADP,

3 7563

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5557

How to get number of days in a given year?

ADP,

4 8654

Explain SELF JOIN ?

ADP,

3 7344

What is Index ? Explain its Types?

ADP,

2 7698

Define Foreign Key?

ADP, College School Exams Tests,

3 8715

Un-Answered Questions { SQL Server }

How to write character string constants or literals in ms sql server?

1019

What is difference between drop truncate and delete?

1092

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

What are the advantages of log shipping?

995

Determine when to use stored procedure to complete sql server tasks?

1054

Explain database normalization?

1221

What is a view in sql?

976

Do comments need to go in a special place in sql server 2005?

856

What is dimension table? : sql server analysis services, ssas

1018

What is the use of sql profiler in sql server 2012?

897

How to change the password of a login name in ms sql server?

1013

What is optimistic concurrency?

1038

What is difference between standardization and normalization?

1101

What is logshipping and its purpose?

990

Is the log file is a part of file group?

1039

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