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 8119

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

ABCO,

2 9281

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7330

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,

2186

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 6536

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 5912

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

2042

what is Equity join?

ADP,

2 7087

How to get number of days in a given year?

ADP,

4 7311

Differencr Between DELETE and TRUNCATE?

ADP,

3 7414

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5449

How to get number of days in a given year?

ADP,

4 8479

Explain SELF JOIN ?

ADP,

3 7208

What is Index ? Explain its Types?

ADP,

2 7570

Define Foreign Key?

ADP, College School Exams Tests,

3 8589

Un-Answered Questions { SQL Server }

Explain the rules for designing files and file groups in sql server?

944

What is the simplest way to create a new database in ms sql server?

964

What are the steps you should follow to start sql server in single-user mode?

854

What is the significance of master, tempdb and model databases?

1034

What are built in functions?

958

What are the ways available in sql server to execute sql statements?

1051

how to create “alternate row colour”?

144

What is SQL Server?

1154

Does group by sort data?

856

What types of Joins are possible with Sql Server?

1069

if no size is defined while creating the database, what size will the database have? : Sql server administration

943

Explain view in sql server?

1017

A trigger can reference objects outside the current database? State true or false.

952

What is Cross Join and in which scenario do we use Cross Join?

982

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1911

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