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

Why people hate cursor?

1202

Find first and last day of current month in sql server

1080

How to handle error or exception in sql?

1030

How to create function without parameter in sql server?

1103

How to select true false based on column value in sql server?

1081

what's new in sql server 2016?

1000

What is @@error in sql?

1106

Why use triggers?

1068

What is store procedure?

1111

What is @@rowcount in sql?

1056

What is a functions and types in sql server?

1143

When you use @@error and try-catch?

1086

What is store procedure? How do they work?

1066

What is sql view?

1115

How to change server name in sql server?

1243

Un-Answered Questions { SQL Server }

What is log ldf?

1042

What is 1nf 2nf?

1057

How to generate create procedure script on an existing stored procedure?

1060

Write a program to fetch first 10 records from a file?

1060

What are the database objects? : SQL Server Architecture

1094

What are a database and a data warehouse?

1069

Explain about remote stored procedure?

1056

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1073

What is a covered index?

984

What is the default Port No on which SQL Server listens?

1174

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4453

How does Report Builder support Analysis Services cubes?

158

How would you go about developing a ssrs report?

174

What is the purpose of sql profiler in sql server? : sql server database administration

1156

What is read committed?

1167

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