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

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 4867

CTE(common table expression)

Thomson Reuters,

1 9109

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13203

what is Covering Index ?

Thomson Reuters,

3 7423

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

Satyam,

2285

Diffrences between sql server 2000 vs 2008

TCS,

2104

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

TCS,

1 6796

how can we know that how many users are connected in perticuler server??????

2 5813

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13741

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 3680

how to insert the values in 5 table at a time Using any single statement ?

Infosys, Value Labs,

6 12000

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

IBM,

3013

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1 1904

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

Ness Technologies,

1 4899

What are the benefits of using stored procedures over sql statements?

Ness Technologies,

3 8473

Un-Answered Questions { SQL Server }

How to connect php with different port numbers?

1159

What are the different types of subquery?

1222

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

1015

What is sql server query analyzer?

1111

Explain system functions or built-in functions? What are different types of system functions?

1052

Can we do dml on views?

1024

what is spatial nonclustered index

1047

What is standby servers? Explain types of standby servers.

1067

How do I start sql server 2017?

1000

What kind of problems occurs if we do not implement proper locking strategy?

1479

What is temporary table in sql server? Why we use temp table?

1000

How to convert character strings into numeric values?

1166

What are different types of constraints?

981

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

1055

How do I find the sql server version?

1096

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