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 8077

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

ABCO,

2 9274

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7321

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,

2182

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 6523

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 5890

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

2034

what is Equity join?

ADP,

2 7064

How to get number of days in a given year?

ADP,

4 7295

Differencr Between DELETE and TRUNCATE?

ADP,

3 7396

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 5441

How to get number of days in a given year?

ADP,

4 8443

Explain SELF JOIN ?

ADP,

3 7196

What is Index ? Explain its Types?

ADP,

2 7556

Define Foreign Key?

ADP, College School Exams Tests,

3 8574

Un-Answered Questions { SQL Server }

What are .mdf files?

888

How sql server executes a statement with nested subqueries?

962

is it important for a database administrator to understand the operating system and file access? : Sql server administration

979

What should be the fill factor for indexes created on tables? : sql server database administration

1101

How to replace null values in expressions using isnull()?

1052

What is sql injection? How to protect against sql injection attack?

943

What is a system database and what is a user database?

1031

What does REVERT do in SQL Server 2005?

919

What is user-defined functions? What are the types of user-defined functions that can be created?

981

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

992

How to see existing views in ms sql server?

989

Why and when do stored procedure recompile?

931

Can we call future method from queueable?

996

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1010

How fixed length strings are truncated and padded?

942

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