Answer / ruchi

A view is a virtual table that consists of columns from one
or more tables. Though it is similar to a table, it is
stored in the database. It is a query stored as an object.
Hence, a view is an object that derives its data from one or
more tables. These tables are referred to as base or
underlying tables.

Once you have defined a view, you can reference it like any
other table in a database.
CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]
Where:


A stored procedure is nothing more than prepared SQL code
that you save so you can reuse the code over and over again.
So if you think about a query that you write over and over
again, instead of having to write that query each time you
would save it as a stored procedure and then just call the
stored procedure to execute the SQL code that you saved as
part of the stored procedure.

Answer / asif aslam

In views we can access data with a page,not like session b/w
the pages.
Stored Procedure use for Database communication...
For Example: add,remove,update etc any record from database.

How to perform sorting on a table in ADO.NET?

0 Answers   Petranics Solutions,

---

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

5 Answers   IBM, Veegyapan Impacts,

---

What is meant by executenonquery?

0 Answers  

---

What does ado stand for in ado.net?

0 Answers  

---

Does executenonquery return a value?

0 Answers  

---

Which object needs to be closed?

0 Answers  

---

can u tell me the why ADO does not support xml..

2 Answers   Crea,

---

What is ado and rdo?

0 Answers  

---

Explain the difference in record set and dataset?

0 Answers  

---

Give few examples of datareader that is used in different dataproviders.

0 Answers  

---

Which are the different IsolationLevels ?

3 Answers  

---

What are all components of ADO.Net data provider?

0 Answers  

---