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,

1135

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

Microsoft,

1096

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

MindCracker,

1120

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

MCN Solutions,

1014

How to create a Master database in SQL server ?

MCN Solutions,

1088

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

MCN Solutions,

1208

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

HCL,

1104

Show Practically Sql Server Views are updatable?

QuestPond,

1123

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1093

What is dynamic cursor in SQL SERVER?

1079

How you can change the database name in SQL SERVER?

1192

how we use window authentication connection with sql server.?

MCN Solutions,

1152

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

Wipro,

1145

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

Infosys,

1094

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

Petranics Solutions,

963

Un-Answered Questions { SQL Server }

How do I find the sql server instance name?

966

Explain what are commit and rollback in sql?

931

What does indexation mean?

973

What is correlated subquery in sql server?

1072

How to list all schemas in a database?

1056

What is db stored procedure?

880

What are the acid properties?

1005

What is sql azure database?

206

Detail about query optimizer?

1103

What is query processing?

935

What stored by the msdb?

1000

What are the recovery models for a database?

1103

What is difference between commit and rollback when used in transactions?

959

What do you mean by data integrity?

1068

What are the types of dml?

978

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