| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| 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 | 3 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| What is a transaction and what are ACID properties? | | 2 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| Can you have a nested transaction? | HCL | 3 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| Hi SQL gurus,
i am working for an MNC...
My team is having a problem in sql server. when user slects
date prompts from jan 1st to april 30, it should display
all months data like :
jan aa
feb bb
mar cc
but when it comes to april its taking data like :
jan aa
feb bb
mar cc
apr dd...and so on
means its taking data again from jan to april which we dont
want. we want the data only april month as we are getting
jan, feb and mar...
can any one write the code to relsove the issue please
would be greatful if you can send to shiva_sans@yahoo.co.in
and also please send your email also ...so that we will be
in touch for any kind of queries ...
Thanks a lot in Advance !!!
| | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| How will u get 5 years back record? | | 4 |
| How to tune a stored procedure? | | 5 |
| Explain Different types of Projects? | | 1 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| i need some interview questions on sql server developer plz
any onee send some links. | | 1 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| What is ACID Property of Transaction? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
