SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 7410

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 4314

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 4187




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

TCS,

846

how to replace double quotes by single quotes in sql server

CAC,

2 9463

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 3253

what is for foreign key ??

Sabic, CarrizalSoft Technologies,

4 3984

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 5776




What is SQL Profiler what is the use of it?

Steria, 247Customer,

2 9965

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

247Customer,

4 11197

How many types of cursors are there in SQL Server?

247Customer, CarrizalSoft Technologies,

5 16245

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

247Customer,

5 5245

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 3257

Differences between functions and stored procedures?

Accenture, 247Customer,

8 8737

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

247Customer,

12 7906


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

role of sql sever 2005 in database rather than any other database

834


How much memory that we are using in Logshipping Concept?

660


how to use DTS package in 2000,2005,2008 in sql server

733


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1194


what is checksum in sql server.........???

338






You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1006


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

812


You are doing log shipping due to some reasons it is failing. How you will proceed from there

770


how to overcome kernel isssues

435


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1244


ow to bring suspect mode datbase online from scratch

644


How do you Implement SSIS Packages in your Project?

789


Working with TLogs

640


how to do partition in sqlserver

1264


query processing

956