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

What is the Main Difference between ACCESS and SQL SERVER?

MindCracker,

1133

How to throw custom exception in Stored Procedure?

MCN Solutions,

1044

What is the difference between stored procedure and functions?

MCN Solutions,

1133

How to replace the Query Result 'Null Value' with a text ?

MCN Solutions,

1041

Can you insert NULL in unique column?

MCN Solutions,

1161

How will you find out if there are expensive SQL statements running or not?

Atos Origin,

1015

Some queries related to SQL

Motorola,

982

What are the different methods available under sqlcommand class to access the data?

UGC Corporation,

1120

What do you mean by SQL injection attack?

Ittiam Systems,

1066

What is Command line parameters in PLSQL.?

MCN Solutions,

1128

What is Sqlpaging in SqlServer 2005 ?

MCN Solutions,

1065

What is a DBMS, query, SQL?

Maveric,

1046

What is difference between Datepart() and Datename() in SqlServer?

Infosys,

1203

What is the difference between SQL notification and SQL invalidation?

MindCracker,

1185

What is the difference between mysql and mysqli?

HCL,

1202

Un-Answered Questions { SQL Server }

Can a unique index be created on a column, which contains null?

919

What is normalization and what are the advantages of it?

985

what is the maximum size of a row? : Sql server database administration

1014

Differentiate between mongodb vs. Sql server?

1095

What is 3nf normalization form?

1111

Define indexes?

1042

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1393

Do you know how to store and query spatial data?

1038

What are the 3 types of schema?

1110

What are types of storage modes? : sql server analysis services, ssas

1039

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

983

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

900

How real and float literal values are rounded?

1157

Why functions are used in sql server?

960

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