SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 7261

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 4232

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 4143

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



how to replace double quotes by single quotes in sql server


2 9279

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 3207

what is for foreign key ??

Sabic, CarrizalSoft Technologies,

4 3938

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


9 5695

What is SQL Profiler what is the use of it?

Steria, 247Customer,

2 9801

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


4 11031

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 16070

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


5 5176

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.


3 3185

Differences between functions and stored procedures?

Accenture, 247Customer,

8 8625

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


12 7800

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

your distribution database is full what will u do


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


application server is slow what may be the problem


How to trouble shoot if unable to connect SQL Server


whats the maximum size of view state??


Scalability, Availability, Integration with internet, etc.)?


how can u get last observation in an unknown dataset ?


sql database suspect We have a sql database that is showing as suspect. How can we recover?


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


what is package and it uses and how can u call a package


how many no of arguments can be passed in procedures and functions


what is difference between view and Dip.


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail