Answer / mkd

A subquery is a SELECT statement that is nested within
another T-SQL statement. A subquery SELECT statement if
executed independently of the T-SQL statement, in which it
is nested, will return a result set. Meaning a subquery
SELECT statement can standalone and is not depended on the
statement in which it is nested.

Sometimes the criteria for determining which set of records
will be affected by a SELECT, UPDATE, DELETE and/or INSERT
statement cannot be obtained by hard coding the selection
criteria. Occasionally there is a need to use the results
of a SELECT statement to help determine which records are
returned or are affected by a T-SQL statement. When a
SELECT statement is used inside another statement, the
inside SELECT statement is known as a subquery.

Answer / c suresh kumar

sub query is part of main query.this useful we retrive data
from the another table.

Answer / swapna

Subquery is used to get information from a table based on
unknown conditions.
If select stmt not perform entire task using
selection,projection,and joins then we can perform that
type of task using sub queries.

Questions regarding Raiseerror?

1 Answers  

---

how to dispaly a particular row details from a given table

2 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

What are the 3 types of schema?

0 Answers  

---

What is tabulation?

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

What is difference between stored procedure and user defined function?

0 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---