SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 7751

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 4476

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

Wipro, RND Soft,

3 4264




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

TCS,

904

how to replace double quotes by single quotes in sql server

CAC,

2 9704

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 3349

what is for foreign key ??

Sabic, CarrizalSoft Technologies,

4 4105

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 5943




What is SQL Profiler what is the use of it?

Steria, 247Customer,

2 10203

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

247Customer,

4 11463

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 16583

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

247Customer,

5 5383

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 3351

Differences between functions and stored procedures?

Accenture, 247Customer,

8 8933

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

247Customer,

12 8131


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1501


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

881


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

808


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

676


How can we call UDF(User Define Function) using C# code in ASP.net ?

4678






In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

873


last function used in MS Access to convert sql what function will use in sql

853


What is RMS migrations?

954


Delete duplicate rows without using rowid.

190


what are the critical issues you have resloved in your company

823


how to overcome kernel isssues

468


If the job running very slow what is the action you do

713


what is isolation level at dead lock?

1008


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

809


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

655