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 are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

QuestPond,

1178

What is the default port for SQL Server over a firewall?

Microsoft,

1142

What is the syntax for encrypting a column in SQL Server?

MindCracker,

1172

what is difference between NULL and ISNULL in SQL Server 2008?

MCN Solutions,

1058

How to create a Master database in SQL server ?

MCN Solutions,

1138

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

MCN Solutions,

1258

Difference between LEN() and DATALENGTH() in sql server ?

HCL,

1170

Show Practically Sql Server Views are updatable?

QuestPond,

1187

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1166

What is dynamic cursor in SQL SERVER?

1135

How you can change the database name in SQL SERVER?

1249

how we use window authentication connection with sql server.?

MCN Solutions,

1209

How display code or Text of Stored Procedure using Sql query in Sql Server ?

Wipro,

1195

Difference between connected and disconnected database in .net with sql server?

Infosys,

1147

Give the query of getting last two records from the table in SQL SERVER?

Petranics Solutions,

1008

Un-Answered Questions { SQL Server }

What are the common performance issues in sql server?

971

Determine when an index is appropriate?

1129

How to use wildcard characters in like operations in ms sql server?

1186

What is a collation in ms sql server?

1132

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

1035

What is local temp table?

1022

What is the difference between stored procedure and user defined functions?

1233

What is log shipping?

998

What is scrollable cursor?

1080

Determine when to use stored procedure to complete sql server tasks?

1107

What stored procedure can you use to display the current processes?

939

What are the advantages of partitioning?

1177

How to insert new line characters into strings?

1033

What are the types of table?

1028

what is the difference between openrowset and openquery?

1155

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