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 11796

Can anybody explain me cold backup and hot backup?

TCS,

3 16176

whate is advantages of sql server 2000

2161

what is the purpose of creating view is sql server 2000

Wipro,

13 22160

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

1 4842

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 6541

how to connect sybase to sql server 2005?.

ABC,

1 5617

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

11 19020

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

4 13999

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

Semantic Space,

11 34975

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 6928

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 8778

what is difference between view and Dip.

IBM, L&T,

2409

what is curser.

9 13653

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

TCS,

5 14572

Un-Answered Questions { SQL Server }

What is a primary index?

924

State the difference between local and global temporary tables?

1119

How to generate create procedure script on an existing stored procedure?

1010

What is triggers and its types?

1009

How can you check the level of fragmentation on a table?

1045

What is the tcp/ip port on which sql server runs?

1160

Explain the different types of joins?

997

Characterize join and name diverse sorts of joins?

966

Define views.

1012

Explain the first normal form(1nf)?

1025

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

963

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148

How to insert and update data into a table with "insert" and "update" statements?

987

How to insert multiple rows with a subquery?

1132

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1064

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