SQL Server Interview Questions
Questions Answers Views Company eMail

what is the output for this query select * from employee where 1=1;

4 13192

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 8814

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 6292

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

TCS,

1719

how to replace double quotes by single quotes in sql server

CAC,

2 12511

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 5632

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 6538

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 9912

What is SQL Profiler what is the use of it?

247Customer, Steria,

2 12455

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

247Customer,

4 15285

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 20872

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

247Customer,

5 8271

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 5453

Differences between functions and stored procedures?

247Customer, Accenture,

8 13644

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

247Customer,

12 13782


Un-Answered Questions { SQL Server }

What are the differences between decimal and float in ms sql server?

656


What is TDS(Tabular Data Stream) Gateway?

111


What are the commands used in DCL?

641


can SSRS reports Cache results?

115


What is SubQuery in SQL Server 2008

642






How to view existing indexes on an given table using sys.indexes?

698


How many replicas are maintained for each SQL Azure database?

134


What are different types of collation sensitivity?

627


how many type of indexing in database?

658


What does nvl stand for?

634


How to set a database state to offline in ms sql server?

621


what are the different stages of Report Processing?

105


Difference between uniqe index and uniqe constraint?

645


Explain full-text indexing?

596


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

703