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

How to insert multiple rows with one insert statement in ms sql server?

1123

How to drop existing views from a database in ms sql server?

1102

What is open database communication (odbc)?

1063

What are the underflow and overflow behaviors on float literals?

1113

How to create new tables with "select ... Into" statements in ms sql server?

990

Can group functions be used in the order by clause in ms sql server?

1013

Can you pass expressions to stored procedure parameters?

1033

How to return the top 5 rows from a select query in ms sql server?

1137

How to add more data to the testing table in ms sql server?

1087

How to declare and use cursor variables?

1169

How to use "begin ... End" statement structures in ms sql server?

1042

How to create a simple stored procedure in ms sql server?

1025

How to execute a stored procedure in ms sql server?

1176

What is a select query statement in ms sql server?

1074

How to rename an existing column with sql server management studio?

999

Un-Answered Questions { SQL Server }

What is a benefit of using an after insert trigger over using a before insert trigger?

985

What is tabulation?

951

Explain about system stored procedure?

1033

Can two different columns be merged into single column? Show practically?

1066

Can coalesce return null?

1013

What is table join?

1114

Explain the creation and execution of a user-defined function in the sql server?

1051

Explain what is use of dbcc commands?

1057

Explain full-text query in sql server?

1005

When would you use sql joins?

959

How to store and query spatial data?

993

last function used in MS Access to convert sql what function will use in sql

2070

Why do we use stored procedures in sql server?

939

What is an index in sql?

1006

Using the customer, and order table in northwind database, please write a query to produce xml?

1075

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