Answer / g.ramesh

It produce Result Set which contains matched rows and left
table unmatched rows.

Answer / prasanna

The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.

What does the automatic recovery do?

1 Answers  

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

Explain how many normalization forms?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

Explain important index characteristics?

0 Answers  

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

What is raid and what are different types of raid levels?

0 Answers  

---

How many ways to create table-valued functions?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

Do you know what are the reporting services components?

0 Answers  

---