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

1 01 101 01010

2100

Find top Nth employee from each department in terms of salary?

RealPage,

13 26152

How to get last system shutdown time in Sql server when restarted system?

1 9159

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

Hewitt,

9 12110

How will you collect the date from current date to last older 6 days date in sql server 2005

4 6387

how we can store the value like that 001,003,023 etc in sql server 2005

7 9586

Selet all the data from table where last name is n of employee

2 5412

How to find the latest updated value in a table without sending any parameters to that query

2 5687

how to improve the speed of SQL database server and how to avoid dead lock?

TCS,

1 6193

What is the disadvantages of index?

TCS,

3 8773

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 4618

select names starts with a,b,c

Scope International,

8 14424

How to convert a table data in XML format in sql server?

2595

how to do partition in sqlserver

TCS,

2546

can any body tell me how to know the password of current user in sql server

Crea, HCL,

2119

Un-Answered Questions { SQL Server }

how to define testing of network layers? : Sql server database administration

1021

How can delete duplicate records in cte in sql server?

1015

What are cursors stored procedures and triggers?

1082

How to connect php with different port numbers?

1147

Tell me about the approaches which you used to counter the DI problems.

1427

What is a rollup clause?

1018

How to run sql server 2005 books online on your local system?

1000

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1030

What are system databases into sql server (2005/2008) : sql server database administration

1052

How to create a new table in a given schema?

1254

How do triggers work?

994

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

Do you know what are the ways available in sql server to execute sql statements?

1082

What are the advantages of log shipping?

1039

What is a document index?

1075

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