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

IN Vs OR operator which is best to use sql server.

4 11775

Can anybody explain me cold backup and hot backup?

TCS,

3 16162

whate is advantages of sql server 2000

2152

what is the purpose of creating view is sql server 2000

Wipro,

13 22116

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 4834

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 6526

how to connect sybase to sql server 2005?.

ABC,

1 5596

how to select a field with firstletter as capital and remaining are small letters

11 18995

How to write stored procedure to update the data in 10 tables

4 13974

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 34914

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 6911

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 8734

what is difference between view and Dip.

IBM, L&T,

2405

what is curser.

9 13592

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 14557

Un-Answered Questions { SQL Server }

Write query to return all rows sql?

1049

How do I manually uninstall an instance of sql server 2016?

1026

What are the differences between lost updates and uncommitted dependencies?

1067

Define ACID properties in a Database?

1051

Explain powershell included in sql server 2008?

1045

What are sql servers used for?

1038

What is the difference between mysql and mysqli?

1185

How to get the query of a table in sql server?

892

Name and describe few console utilities for ssrs?

284

Which tools are available to manage SQL Azure databases and servers?

115

What is cube dimension? : sql server analysis services, ssas

998

What are the differences between stored procedure and view in sql server?

1235

What is a trigger and its types?

978

What is lock escalation? : sql server database administration

1148

What is tempdb database? : SQL Server Architecture

1182

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