SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 7830

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 4532

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 4280




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

TCS,

913

how to replace double quotes by single quotes in sql server

CAC,

2 9782

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 3374

what is for foreign key ??

Sabic, CarrizalSoft Technologies,

4 4145

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 5992




What is SQL Profiler what is the use of it?

Steria, 247Customer,

2 10253

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

247Customer,

4 11530

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 16663

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

247Customer,

5 5439

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 3384

Differences between functions and stored procedures?

Accenture, 247Customer,

8 8990

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

247Customer,

12 8198


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Comment,Datatypes are unlimited

936


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

1158


SQL Server Architecture ?

1149


How to trouble shoot if unable to connect SQL Server

783


What is Lock table in SQL?

283






How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2694


Why we need to use secondry database file? though, we can do same work using primary database file also.

4249


How retrieve field names from the table in SQL through JAVA code?

722


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 ...

952


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

793


How to restore performance issues and how to check?

861


What are the dis_advantages of stored procedures, triggers, indexes?

982


How to convert a table data in XML format in sql server?

1417


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

865


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

890