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 11949

Can anybody explain me cold backup and hot backup?

TCS,

3 16339

whate is advantages of sql server 2000

2235

what is the purpose of creating view is sql server 2000

Wipro,

13 22626

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

1 4912

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 6706

how to connect sybase to sql server 2005?.

ABC,

1 5690

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

11 19412

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

4 14188

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

Semantic Space,

11 35368

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 7040

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 8954

what is difference between view and Dip.

IBM, L&T,

2461

what is curser.

9 13961

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

TCS,

5 14742

Un-Answered Questions { SQL Server }

What is the difference between functions and stored procedures?

1230

How to perform key word search in tables?

1011

Which sql server is best?

1055

What is sql server 2000 work load governor?

1164

What are the types of dml?

1034

How can you know if the row fetched from cursor is still valid in underlying table?

1048

What is meant by indexing files?

1103

Explain few examples of stored procedure over triggers?

1125

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1199

What is temporal table?

944

What is update locks?

942

What is subquery in sql?

1131

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1104

What is used to replicate sessions between instances in coldfusion clusters?

1107

How to use "begin ... End" statement structures in ms sql server?

1123

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