Answer / Nikhil Kumar

A view is a virtual table based on the result-set of an SQL statement. It does not store data, but instead contains the SQL code to compute the data.

How do you send email on SQL Server?

1 Answers   MindCracker,

---

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  

---

When I delete any data from a table, does the sql server reduce the size of that table?

1 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

What is change tracking in sql server?

1 Answers  

---

What is difference between rownum and row_number?

1 Answers  

---

What is constraints and its types?

1 Answers  

---

Why can there be only one clustered index and not more than one?

1 Answers  

---

What are the types of processing and explain each? : sql server analysis services, ssas

1 Answers  

---

Explain the disadvantages/limitation of the cursor?

1 Answers  

---

What is lookup override?

1 Answers   Informatica,

---

What do you understand by the analysis services in sql server?

1 Answers  

---