1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

 4 12825

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 8271

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 5954

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

TCS,

1607

how to replace double quotes by single quotes in sql server

CAC,

2 12308

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 5265

what is for foreign key ??

CarrizalSoft Technologies, Sabic,

4 6215

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 9326

What is SQL Profiler what is the use of it?

247Customer, Steria,

2 12182

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

247Customer,

4 14866

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 20418

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

247Customer,

5 7923

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 5148

Differences between functions and stored procedures?

247Customer, Accenture,

8 13013

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

247Customer,

12 12876

Un-Answered Questions { SQL Server }

What happens if strings are casted into wrong code pages in ms sql server?

560

What is sqlservr.exe - process - sql server (sqlex?press)?

590

How do I install only the client tools of sql server 2000?

541

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2202

What is the difference between executequery () and executeupdate ()?

507




What is the contrast between sql and mysql?

584

What is the datatype of rowid?

500

How can I create a new template for import ? : sql server management studio

587

How does a profiler work?

508

What is built-in/administrator?

567

Explain user defined views?

566

What happens if ntwdblib.dll is missing on your machine?

626

How to apply filtering criteria at group level with the having clause in ms sql server?

549

What is a mutating table error and how can you get around it?

529

What are sql server functions?

503

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