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

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8170

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 18916

Which system tables contain information on privileges granted and privileges obtained

1 7172

Which system table contains information on constraints on all the tables created?

2 7433

what command is used to create a table by copying the structure of another table?

7 15135

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 9871

What is the use of CASCADE CONSTRAINTS?

3 11447

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

1 2082

What are the type of Indexes? which one is best, why?

6 9938

How to work on DTS?what is the main requirement?

Getit, ivan,

1 5871

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

37 70183

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 185531

About types of indexes in SQL server ?

Cognizant,

2 7953

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 77644

About DTS usage ?

Cognizant, Wipro,

2 8236

Un-Answered Questions { SQL Server }

what is the difference between openrowset and openquery?

1174

What is subquery? Explain the properties of a subquery?

1046

What is sql server query analyzer?

1111

Why use identity in sql server?

1185

How to provide default values to function parameters?

1235

What is self contained sub query?

1130

Equi join and non equi join is possible with sql server?

1110

Can we do dml on views?

1024

How raid can influence database performance?

1093

What is the primary use of the model database?

1141

How to remove duplicate rows from table except one?

1070

What is a view in sql?

1033

How efficient you are in oracle and SQL server?

1234

How can I check that whether automatic statistic update is enabled or not?

1101

How to convert character strings into numeric values?

1167

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