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 8395

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

ABCO,

2 9379

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7451

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,

2235

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 6621

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 6046

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

2079

what is Equity join?

ADP,

2 7178

How to get number of days in a given year?

ADP,

4 7479

Differencr Between DELETE and TRUNCATE?

ADP,

3 7549

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5541

How to get number of days in a given year?

ADP,

4 8627

Explain SELF JOIN ?

ADP,

3 7333

What is Index ? Explain its Types?

ADP,

2 7687

Define Foreign Key?

ADP, College School Exams Tests,

3 8693

Un-Answered Questions { SQL Server }

How to connect to a sql server using odbc_connect()?

1142

How is SQL Azure different than SQL server?

223

Why transaction is important?

971

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1249

Explain few of the new features of sql server 2008 management studio

908

Explain boyce and codd normal form(bcnf)?

940

What is best institute to Learn DotNET And SQL in chennai?

2161

What is filestream?

994

How to convert character strings into numeric values?

1092

Explain user defined views?

957

What is filter index?

945

Why do we backup Active Directory ?

1036

What is outer join in sql server joins?

1112

Can we insert data into view sql server?

924

What are the different types of cursor?

1090

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