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 the output for this query select * from employee where 1=1;

4 14307

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 10359

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

RND Soft, Wipro,

3 7183

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

TCS,

2071

how to replace double quotes by single quotes in sql server

CAC,

2 13292

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 6855

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 7607

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

TCS,

9 11632

What is SQL Profiler what is the use of it?

247Customer, Steria,

2 13337

What are the advantages of using views. Why do we need views when we have SPs?

247Customer,

4 16582

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 22483

What is the difference between the following two sql statements select count(*) from select count(col_name) from

247Customer,

5 9550

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

247Customer,

3 6390

Differences between functions and stored procedures?

247Customer, Accenture,

8 15716

Can we have more than one NULL in a column having unique constraint?

247Customer,

12 16546

Un-Answered Questions { SQL Server }

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

How to list all user names in a database?

1057

Explain microsoft sql server functions?

1109

How to replace given values with null using nullif()?

987

What is the filtered index?

1057

How can we determine what objects a user-defined function depends upon?

1012

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

906

Explain error handling in ssis?

1023

What is a trigger and types of a trigger?

983

explain different types of constraints? : Sql server database administration

957

please differentiate between delete and truncate?

993

how to overcome kernel isssues

1625

Can we use max in where clause?

925

Explain the steps to create and execute a user-defined function in the sql server?

967

How to add the custom code in Report?

126

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