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 11969

Can anybody explain me cold backup and hot backup?

TCS,

3 16354

whate is advantages of sql server 2000

2240

what is the purpose of creating view is sql server 2000

Wipro,

13 22698

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

1 4919

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 6724

how to connect sybase to sql server 2005?.

ABC,

1 5704

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

11 19433

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

4 14207

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

Semantic Space,

11 35404

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 7059

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 8973

what is difference between view and Dip.

IBM, L&T,

2462

what is curser.

9 13994

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

TCS,

5 14766

Un-Answered Questions { SQL Server }

How column data types are determined in a view?

1019

Write a query for primary key constraint with identity key word?

1089

What are the features of Embedded SQL

1181

How many types of objects are there?

1081

What is the use of nvl work?

1049

Is there any difference between primary key and unique with the not null condition?

1007

Explain what is scheduled job and how to create it?

1026

What is ddl and dml commands?

966

Can two tables have the same primary key?

1279

What is a database table?

1028

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

What is faster join or union?

1330

What is unpivot?

1082

Do you have any idea about the tcl commands?

1022

What are the differences between stored procedure and the dynamic sql?

1144

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