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

How get current date in SQL server 2000

Cap Gemini, Polaris,

4 7057

How get current date in SQL server 2000

Cap Gemini,

6 9705

In the primary key have a multiple field or not?

TCS,

8 9557

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

PMAM IT Services, TCS,

7 10121

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1 2104

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1 2102

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 6245

what are the critical issues you have resloved in your company

Wipro,

1 2034

how can you move the master database

IBM,

1 4817

What is RMS migrations?

Satyam,

1 2204

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 11515

What is split brain scenario in DB mirroring?

1 11524

how do we insert 100 records at a time in a table without using for loop in database

1 4955

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 8190

in how many ways we can use count()

2 3899

Un-Answered Questions { SQL Server }

What is the difference between for xml raw and for xml auto?

1108

what is spatial nonclustered index

1050

How efficient you are in oracle and SQL server?

1249

what is the difference between openrowset and openquery?

1186

How do I start sql server 2017?

1005

What are the properties of the transaction?

1067

Can you index views?

951

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

Why should you use or avoid select * statements?

1103

What is sql server query analyzer?

1116

How can you append an identity column to a temporary table?

1063

What are the kinds of subquery?

1093

do you know how to configure db2 side of the application? : Sql server database administration

1113

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1059

What is sql or structured query language?

1212

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